SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

querying a table using timestamp

Mark ReichmanOct 4 2006 — edited Oct 4 2006

9i database...

Somebody truncated a table.. We need to get the data back... I dont believe Flashback query will work because the undo_retention is not set. At least thats what the DBA says..

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6135698985750#6141337947300

According to Tom Kyte there is another way.. RBS... So, I did this...

select *
from accident as of timestamp sysdate-2 b
minus
select *
from accident;

And I got this...

ORA-01466: unable to read data - table definition has changed

But, the table definition has not changed... Sup?

Message was edited by:
Mark Reichman

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2006

Added on Oct 4 2006

7 comments

601 views