| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;- works in TOAD not in 9i SQL*plus
Curiosum - try
SQL> UPSERT XYZ ;
You get a real ORA- error, as it is a valid SQL command in SQL*Plus's
opinion, but the server doesn't think so.
SQL> UPZERT XYZ
gives a sqlplus error, just like your FLASHBACK.
The reason is the SQL MERGE command was called UPSERT for a some time in 9ibeta, but then they changed it. Someone didnt clean out SQL*Plus's old defenition. They fixed it in SQL*Plus 10g.
M-square
-- (via Webmail) ---------- Original Message ----------- From: "Arup Nanda" <orarup_at_hotmail.com> To: <oracle-l_at_freelists.org> Sent: Wed, 10 Mar 2004 00:29:19 -0500 Subject: Re: FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;- works in TOAD not in 9i SQL*plusReceived on Thu Mar 11 2004 - 11:35:17 CST
> 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
> -----------------------------------------------------------------
------- End of Original Message ------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------
 |
 |