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

    Unanswered: I can't purge recyclebin

    I use Oracle 10g (Oracle Database 10g Enterprise Edition Release 10.1.0.3.0)
    and I log in as sys user, but I can't purge tablespace:
    this is the error:

    SQL> show user
    USER Φ "SYS"
    SQL>
    SQL> select tablespace_name from dba_data_files;
    SYSTEM
    UNDOTBS1
    SYSAUX
    DATA
    SQL> purge tablepsace data;
    SP2-0734: unknown command beginning "purge tabl..." - rest of line ignored.
    SQL>


    Can You help me?

    thank you very much

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    miss spelling?

    purge tablespace data;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Feb 2005
    Posts
    2
    Thank You
    but don't resolve the initial problem.

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    if you want to remove recylebin -- and then loosing Flashback capability

    you can make use of the alter system command

    alter system set _recylebin=false (maybe scope both)

    or do you want
    purge recylebin; ???

Posting Permissions

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