Re: PURGE Command SQL or SQL*Plus Command?

9i doesnt know what purge is, it parses the command for you first (thats why you get an SP2 error, not an ORA-) , message

when running its a plsql block then it just sends the commands to the database regardless and the data will try and execute it

On 05/12/06, Ethan Post <post.ethan_at_gmail.com> wrote:
>
> This command is in the 10G SQL documentation, it does not seem to run from
> command line of 9i client, but will work as a PLSQL block.
>
> Is this the case? I need to execute this command from a script using
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 5 10:52:46 2006
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit
> Production
> With the Partitioning, OLAP and Data Mining options
>
> qa>purge recyclebin;
> SP2-0734: unknown command beginning "purge recy..." - rest of line
> ignored.
>
>
>
>
>

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