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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
