Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Provided Answers: 1

    Unhappy Unanswered: Cannot purge recyclebin

    SQL*Plus: Release - 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 - 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.

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

  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    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.

Posting Permissions

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