Re: FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;- works in TOAD not in 9i SQL*plus
- From: "Arup Nanda" <orarup@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 00:29:19 -0500
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
