OraFAQ Forum: SQL & PL/SQL » drop user cascade issue

Home » SQL & PL/SQL » SQL & PL/SQL » drop user cascade issue

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

drop user cascade issue [message #560789]

Tue, 17 July 2012 02:51

neetesh87
Messages: 262
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.....

Report message to a moderator