Database Software

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!

How can i duplicate a schema, rename it and all schema object

AbdurRahmanSep 2 2014 — edited Sep 2 2014

Hello All,
I am faced with an issue on my oracle database 11g,
I want to recreate a schema, rename the schema pull the the objects in the old schema into the new schema and all the objects inside the new schema.
i need to know if there is a script i can write to do these tasks at automatically.

Thanks for your assistance in anticipation

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2014

Added on Sep 2 2014

#database-key-features, #export-import-sql-loader-external-tables

2 comments

1,401 views