aspose file tools*
The moose likes Oracle/OAS and the fly likes Not able to drop user Oracle10.2.0.3 Ent Ed. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Not able to drop user Oracle10.2.0.3 Ent Ed." Watch "Not able to drop user Oracle10.2.0.3 Ent Ed." New topic
Author

Not able to drop user Oracle10.2.0.3 Ent Ed.

Ramakanta Sahoo
Ranch Hand

Joined: Aug 23, 2008
Posts: 254

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


Regards, Ricky
Oracle Weblogic 10g Certified Expert TechPaste.Com
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30294
    
150

What user are you logged in when running this? What tool are you running it through? (sql plus or something else)


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338


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

Joined: Aug 23, 2008
Posts: 254

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

Joined: Oct 06, 2007
Posts: 338
did you run the SQL trace and determine your constraints?
Ramakanta Sahoo
Ranch Hand

Joined: Aug 23, 2008
Posts: 254

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

Joined: Oct 06, 2007
Posts: 338
I believe your user is tied to existing stream... I will try to look at this tonight after I get in from work.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Not able to drop user Oracle10.2.0.3 Ent Ed.