Hi,
My database is 10gR2.Prameter Recyclebin is set to on . The size of the tablespace is
Tablespace Used MB Free MB Total MB Pct. Free
------------------------------ ---------- - --------- ---------- ---------
CC 4469 3651 8120 45
I dropped a table .and now the size of the tablespace is
Tablespace Used MB Free MB Total MB Pct. Free
------------------------------ ---------- - --------- ---------- ---------
CC 3763 4357 8120 54
It shows the table is removed and moved to recycle bin...
SQL> select * from tab where tname like '%BIN%';
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BIN$suEt4WizTf+YuvQQAJ90Kw==$0 TABLE
However in Oracle documentation i read ..."It stays in the same tablespace, with
the same structure as that of the original table. If there are indexes or triggers defined on the table, they are renamed too, using the same naming
convention used by the table.The objects are not moved from the tablespace they were in earlier; they still occupy the space there"
If this is the case ...y the freespce in my tablespace is increased after droppping that table. If my table is stored in same tablespace(recycle bin) the free space should not increase...
please explain this ...
Regards,
Karthick