| Dbms_flashback can not retrieve dropped tables? [message #63051] |
Mon, 06 September 2004 04:46 |
vasanth
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
Dears
I have used dbms_flashback to retrieve delete rows. But using the same concept I colud not retreive a dropped table , even my undo_retention has set to more than the time I needed. Please have a look on the following scenario.
6-sep-04 6:10:00>table sample created
6-sep-04 6:11:10>Four rows inserted into sample table
6-sep-04 6:12:10>commit;
6-sep-04 6:13:10>still rows are available for sample table
6-sep-04 6:14:15>drop table sample;
6-sep-04 6:16:00>I used dbms_flashback.enable_at_time(TO_TIMESTAMP ('6-sep-2004 6:13:10','DD-MON-YYYY HH24:MI:SS'));
now Im unable to retrive the sample table even the database has been moved to the point of time where the table is alive.
instead of drop I deleted all rows. but now it works smoothly and I can retrieve the deleted rows.
Could anyone please help on this issue.
Thanks .
vasanth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
