Help - Search - Members - Calendar
Full Version: Flashback table
Oracle DBA Forums > Oracle > Oracle Forum
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%';

------------------------------ ------- ----------
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 ...

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-2016 Invision Power Services, Inc.