• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Not able to drop user Oracle10.2.0.3 Ent Ed.

 
Ramakanta Sahoo
Ranch Hand
Posts: 256
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I created some users and now I am not able to drop them as system user also. Though I'm able to drop the tablespaces.
Its throwing below errors:

SQL> drop user amr cascade;
drop user amr cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


What could be wrong with database settings or any other params required???


Thanks,
-Ricky
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34870
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What user are you logged in when running this? What tool are you running it through? (sql plus or something else)
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


from the trace file you should be able to identify your issue or there should be enough info to help you resolve the problem.
 
Ramakanta Sahoo
Ranch Hand
Posts: 256
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jeanne Boyarsky wrote:What user are you logged in when running this? What tool are you running it through? (sql plus or something else)


Sqlplus only.

No other tool

User : system
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
did you run the SQL trace and determine your constraints?
 
Ramakanta Sahoo
Ranch Hand
Posts: 256
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Campbell wrote:did you run the SQL trace and determine your constraints?


Hi Idid what you said please find the below attched file.
Sorry for putting it in code as I'm not able to attach the file.



Thanks.
-Ricky
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe your user is tied to existing stream... I will try to look at this tonight after I get in from work.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic