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@xxxxxxxxx> 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.





Other related posts: