DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Problem in drop tablespace

Threaded View

  1. #1
    Join Date
    May 2009
    Location
    Muscat,Oman
    Posts
    11

    Exclamation Problem in drop tablespace

    I WANT TO KNOW IS THIS PROCESS ARE CORRECT FOR DROP A TABLESPACE


    startup open;

    alter tablespace raja offline;


    SQL> DROP TABLESPACE RAJA INCLUDING CONTENTS AND DATAFILES;
    DROP TABLESPACE RAJA INCLUDING CONTENTS AND DATAFILES
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist



    THIS IS THE ERROR I FOUND
    BUT ONCE I DROP ANOTHER TABLESPACE WHICH IS AUTOMATICALLY GENERATED BY THE ORACLE "SYS_UNDOTS"


    SQL> ALTER tablespace SYS_UNDOTS offline;

    Tablespace altered.

    SQL> DROP TABLESPACE SYS_UNDOTS INCLUDING CONTENTS AND DATAFILES ;

    Tablespace dropped.


    THE ABOVE IS WORKING BUT I WANT TO DROP A USER TABLESPACE

    LET ME KNOW THE REASON FOR THIS DIFFERENCE ?
    IS THERE ANY DIFF BETWEEN "SYS_" TABLESPACE AND "USER"(created by dba)

    EVEN I CREATE A NEW TABLESPACE, THAT ALSO CANT ABLE TO DROP.. SAME PROBLEM FOR THAT TOO
    Last edited by abdulhameedom; 05-05-2009 at 05:04 PM. Reason: SAME PROBLEM FOR OTHER NEW TBS

Posting Permissions

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


Click Here to Expand Forum to Full Width