RE: Flashback Query Error

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Wed, 24 Nov 2004 09:54:37 +0100
Message-Id: <20041124085441.EA3CD3D26F8@ha-smtp2.tiscali.nl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 24 2004 - 02:50:23 CST