-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|