flashback version query
the_slkDec 28 2011 — edited Dec 29 2011Hello,
Right now I'm reading about flashback version query.
How query will behave if undo retention time is less than the lower bound time or SCN/Timestamp specified? Can anybody give me a hint?
insert into slk_test_1000 values (11);
delete from slk_test_1000; commit;
insert into slk_test_1000 values (12);
delete from slk_test_1000; commit;
insert into slk_test_1000 values (13);
delete from slk_test_1000; commit;
SELECT *
FROM SLK_TEST_1000
AS OF TIMESTAMP CURRENT_TIMESTAMP - INTERVAL '10' MINUTE;
ORA-01466: unable to read data - table definition has changed
01466. 00000 - "unable to read data - table definition has changed"
*Cause: Query parsed after tbl (or index) change, and executed w/old snapshot
*Action: commit (or rollback) transaction, and re-execute
Is there any scenario that query would not return an error?
Best Regards,
slk