Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    57

    Unhappy Unanswered: Cannot purge recyclebin

    SQL*Plus: Release 9.0.1.4.0 - Production on Thu Feb 24 16:52:33 2005

    (c) Copyright 2001 Oracle Corporation. All rights reserved.

    Connected to:
    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.
    SQL> purge;
    SP2-0042: unknown command "purge" - rest of line ignored.
    SQL>

    Any ideas?
    Is there a script we need to run to make this command available?

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    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.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •