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!

list of all Oracle Created (Default)Database Users list for DB full import?

625546Jan 9 2009 — edited Jan 9 2009

Hi ,

Can someone please give me a list of all Oracle DB version : 10.2.0.3 Created (Default) Database Users list.

and if someone give me a script to delete all unnecessary schemas other than oracle necessary schemas.

Reason is i want to do an full database imp to a test database , i have the exp dump and want to make sure to remove all unnecessary schemas so i can do the import straight away into the db.

is this a easy correct way .

Please advise.

DB version : 10.2.0.3

Thanks
Anto

This post has been answered by Srini Chavali-Oracle on Jan 9 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2009

Added on Jan 9 2009

#database, #db, #general-database-discussions, #import, #list

5 comments

915 views