From oracle-l-bounce@freelists.org Tue Nov 23 16:49:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iANMnGI32527 for ; Tue, 23 Nov 2004 16:49:16 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iANMnGx32522 for ; Tue, 23 Nov 2004 16:49:16 -0600 Received: from localhost (freelists-183.iquest.net [206.53.239.183]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0569372C4E4; Tue, 23 Nov 2004 17:55:35 -0500 (EST) Received: from turing.freelists.org ([206.53.239.180]) by localhost (misc.avenirtech.net [206.53.239.183]) (amavisd-new, port 10024) with ESMTP id 15242-83; Tue, 23 Nov 2004 17:55:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82DE372F519; Tue, 23 Nov 2004 16:33:02 -0500 (EST) Message-ID: <410-2200411223195552864@infionline.net> From: "John P Weatherman Jr." To: "oracle-l" Subject: Flashback Query Error Date: Tue, 23 Nov 2004 14:55:52 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-ELNK-Trace: b4d21b641634dbbe40ea0adc697db4f96818e31467099fbab56dfee55e12038a29721f0e6fc309cd350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 4.152.207.167 Content-Transfer-Encoding: 8bit X-archive-position: 12655 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: asahoshi@infionline.net Precedence: normal Reply-To: asahoshi@infionline.net X-list: oracle-l X-Virus-Scanned: amavisd-new at avenirtech.net 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