I've never used it, but I've been reading up on it...
If you go to http://www.trivadis.ch/publikationen/E/flashbackqr21_en.pdf
under flashback queries limitations it says that dropping the table makes
undo data for the table invalid.

Richard J. Quintin
Software Engineer
VTLS, Inc.
1701 Kraft Dr.
Blacksburg VA 24060
540-557-1200
www.vtls.com


-----Original Message-----
From: Mark [mailto:[Email Address Removed] Sent: Friday, February 28, 2003 2:29 PM
To: LazyDBA.com Discussion
Subject: Flashback - Deleted Tables


I just want to know if DBMS_FLASHBACK will work on deleted tables. I
tried to delete a test table and execute the dbms_flashback and I got an
error of ERROR at line 1:
ORA-00942: table or view does not exist. Retrieving deleted records
(rows) does work in dbms_flashback, how about deleted tables? I tried to
read some documents about DBMS_FLASHBACK but it did not mention anything
about deleted tables.

Thank you guys.



Oracle LazyDBA home page