Skip to Main Content

Oracle Database Discussions

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!

Doubt about drop user cascade

515444Sep 1 2006 — edited Jun 19 2007
Hi,

I'm one doubt about drop user cascade..

Well, I need clear all scheme from database to do one import (from file dump).

i'm making one script to do this... and my doubt is:


if I to catch all user's from dba_user's in one cursor.. and execute drop user cascade to each user returned...

Do user system will be droped ?
I'll get some trouble if I to drop all ?

Sorry if I wrote something hard to understand.
Yours
Fernando.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2007
Added on Sep 1 2006
6 comments
6,289 views