Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DROP USER always CASCADING for all dependent TABLES,VIEWs,....?

pstein-JavaNetFeb 10 2010 — edited Feb 10 2010
Assume I execute a

DROP USER user123;

command. Are in this case ALWAYS all dependent TABLEs, VIEWs, OBJECTs
with user123 as OWNER AUTOMATICALLY deleted as well?

if not: How can I achieve a cascading full delete otherwise?

What is the difference between

DROP USER
and
DROP SCHEMA

?

Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2010
Added on Feb 10 2010
8 comments
4,043 views