O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Flashback Drop with Recycle Bin

In previous releases of the database, when you issued the DROP command to drop a table, all contents of that table were permanently removed from the database. Now, with Oracle 10g Flashback Drop, a dropped table and its dependent objects (such as indexes, constraints, and triggers) are renamed to a system-generated string and logically placed in the recycle bin. Each recycle bin object will physically reside in the same tablespace and schema from which it was dropped. For example, if the DOCUMENTS table was created in the HIGH_GROWTH tablespace, then the dropped DOCUMENTS table will remain in the HIGH_GROWTH tablespace as long as the table remains in the recycle bin.

Once a table is logically placed in the recycle ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required