how to check exact size of database after deleting
Hi,
oracle version : oracle 8.1.7
os : sun solaris
database size 1000gb
we have deleted millions of rows from many tables but we have't workaround to release the space (like export n import, move tables)
now how can i get the actual size of database.
i used to calcaulte database size by using select sum(bytes)/1024/1024 /1024from dba_data_files;
but in my scenerio i have deleted millions of rows how can find how much data actually consuming the space in database aka present database size.
appreciated valuable inputs.
Thanks
Prakash