Hi All,
I am having a table STG_USERS. This has only one column(VARCHAR2(15)). It has no rows now. But when i queried dba_segements table i got "34,366,029,824" bytes against this table. I believe this bytes gives me the size of a table. This table is having 4190474 blocks(saw from sql developer). But i do not have any records in that table.
The biggest table in my schema(having 9M rows, 2GB in size) was having only 145K blocks.
Any idea why is this table is having this many blocks? And dba_segments saying this table is having 32GB?
Kindly let me know if you need anyother information.