Help - Search - Members - Calendar
Full Version: Flashback table
Oracle DBA Forums > Oracle > Oracle Forum
karthickr
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
dave
yes it is free, the space is marked as reusable so if the tablespace becomes full it will overwrite your recyclebin space.

So the space free is correct
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.