var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cannot purge recyclebin
SQL*Plus: Release 220.127.116.11.0 - Production on Thu Feb 24 16:52:33 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> purge recyclebin;
SP2-0734: unknown command beginning "purge recy..." - rest of line ignored.
SP2-0042: unknown command "purge" - rest of line ignored.
Is there a script we need to run to make this command available?
You are using a 9i version of sql*plus, which doesn't know anything about the purge command. Use a 10g version. Sql*Plus has to parse the command before it passes it on to the database engine.
You do not need a parachute to skydive. You only need a parachute to skydive twice.