Thanks again Greg!
Finally under which directory location can I find the databse file (is it a .dbf file).
Sorry for my questions but I am just a month into Oracle.
Thanks in advance for your help.
All i have done till now is create a table in my schema...so I am trying to explore where I can find the data files and their format.
Thanks for the reply.
I do have yet another table though- a log table
has a id, error text and error text2.
The error text 2 is a large filed and may contain BLOBS of data.
How do I find just the size occupied by this one table and not teh whole databse.
alos separately I owuld like to calculate size of the associated synnyms indices, sequqnces, etc for the table.