Home » SQL & PL/SQL » SQL & PL/SQL » drop user cascade issue
drop user cascade issue [message #560789] Tue, 17 July 2012 02:51 Go to next message
neetesh87
Messages: 274
Registered: September 2011
Location: bhopal
Senior Member
hello experts,
sometimes when i go to drop user ,oracle gives an error like-

SQL> show user
USER is "SYS"
SQL> drop user localaepuser
2 /
drop user localaepuser
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'LOCALAEPUSER'


SQL>


but sometimes it drops user witout this cascade error, what is the logic behind this error.
your help will be appreciated.

thanx in advance.....
Re: drop user cascade issue [message #560790 is a reply to message #560789] Tue, 17 July 2012 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must use CASCADE when user owns objects.
Database SQL Reference

Regards
Michel
Re: drop user cascade issue [message #560792 is a reply to message #560790] Tue, 17 July 2012 03:02 Go to previous message
neetesh87
Messages: 274
Registered: September 2011
Location: bhopal
Senior Member
okk.
thanx alot sir,for your response.
Previous Topic: Compile Invalid Objects
Next Topic: Error handing with batch sql scripts
Goto Forum:
  


Current Time: Sat Apr 19 10:32:36 CDT 2014

Total time taken to generate the page: 0.07989 seconds