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 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:
