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

At first glance it looks like a privs issue; the account you are using to log into the database might not have privs on the affected table seatting on raja tablespace.

I'm so proud of myself, I didn't ask what possesed you to drop sys_undots... oops, did I said that out loud?

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:confused::confused::confused:)

Quote:

---

Originally Posted by abdulhameedom

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

---

Quote:

---

Originally Posted by abdulhameedom

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.

---

Please don't take this the wrong way, you look like an adventurous person -chances are software development would be a better fit than database administration for a person with such natural predisposition.

i am really sorry to say,, i hate the development side,, i almost lost my carrier, i want to survive, i dont want to be a looser in this world again,,
i want to be a DBA that is the only way with me,, i already choose it as my future..

To perform any task, you need the privilege to do it. So is for dropping tablespaces, please see if you the privilege to do so.
Well like you said it yourself, if you want to survive as a DBA, then pleasseee don't fiddle with system objects, at least as for now. We'll look at it when you grow a bit older. :P :P

Thank u for ur kind help..
if Gods wish u can see my growth..

thank u once again...:o:rolleyes: