Re: FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;- works in TOAD not in 9i SQL*plus

From: Arup Nanda <orarup_at_hotmail.com>
Date: Wed, 10 Mar 2004 00:29:19 -0500
Message-ID: <BAY12-DAV64URpzEuk90000d963@hotmail.com>

Jay,

Flashback comamnd needs SQL*Plus 10g; it will not work with 9i. SQL*Plus interprets commands; and checks the first word for accuracy. If the first word is not a valid SQL command, it reports an error. dince 9i SQL*Plus does not know the existence of a command called FLASHBACK, it barks at it.

I am not sure why TOAD works; but I can theorize that it simply takes the entire SQL statement and passes to the Oracle engine, which can interpret the comamnd properly.

Hope this helps.

Arup
----- Original Message -----
From: "Jay" <jaysingh1_at_optonline.net>
To: <oracle-l_at_freelists.org>
Sent: Tuesday, March 09, 2004 8:53 PM
Subject: FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;- works in TOAD not in 9i SQL*plus

> Dear All,
>
> I tried 10g "FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;". It did not work
> in 9i client but it worked in TOAD.
> I guess SQL*plus client interprets the command and TOAD is not doing that.
>
>
> C:\>sqlplus sami/sami_at_linux
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 9 20:46:13 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> show recyclebin
> SP2-0158: unknown SHOW option "recyclebin"
> SQL> FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;
> SP2-0734: unknown command beginning "FLASHBACK ..." - rest of line
ignored.
> SQL>
> SQL>
>
> Thanks
> Say
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 09 2004 - 23:09:16 CST