Skip to Main Content

Oracle Database Discussions

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!

Oracle Flashback Query

happy10319Jul 27 2008 — edited Aug 4 2009
Hi,
how to determine the valide lower and higher limits snapshot to avoid the follwing error :

SQL> SELECT * FROM aL_emp
2 VERSIONS BETWEEN TIMESTAMP
3 SYSTIMESTAMP - INTERVAL '100' MINUTE AND
4 SYSTIMESTAMP - INTERVAL '1' MINUTE;
SELECT * FROM aL_emp
*
ERROR at line 1:
ORA-30052: invalid lower limit snapshot expression

And how to find the largest interval ?

Many thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2009
Added on Jul 27 2008
4 comments
3,026 views