i drop the tablespace "SYS_UNDOTS" because it have more space than the "SYSTEM Tablespace", because of that i coudnt able to create a new tablespace.

now am facing the drop tablespace problem..

(am really sorry for disturbing u am just a child in this DBA ocean,, i want to sail in this , so please don't mistaken me by my question)

Quote Originally Posted by abdulhameedom View Post
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