RE: Flashback Query Error
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <asahoshi@xxxxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2004 09:54:37 +0100
John,
You might want to share the actual SQL command with us?
Did you try the MINVALUE and MAXVALUE limits?
Lex.
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John P Weatherman Jr.
Sent: Tuesday, November 23, 2004 20:56
To: oracle-l
Subject: Flashback Query Error
All,
I am starting to experiment with flashback query. When I use the VERSIONS
clause, I keep getting "ORA-30052: invalid lower limit snapshot expression".
I have tried every reasonable set of timestamp values I can come up with,
with no luck. There isn't a lot on this one Metalink or Google. Has anyone
had issues with this or have some idea what may be behind it? I am running
10.1.0.3 on AIX 5.2. This is a 2 node RAC cluster. Any pointers would be
greatly appreciated.
Thanks,
John P Weatherman
Oracle DBA
Advance America
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
