Re: PURGE Command SQL or SQL*Plus Command?

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: post.ethan@xxxxxxxxx
  • Date: Tue, 5 Dec 2006 17:18:17 +0000

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 - 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 - 64bit
With the Partitioning, OLAP and Data Mining options

qa>purge recyclebin;
SP2-0734: unknown command beginning "purge recy..." - rest of line

Other related posts: