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!

How to copy the entire schema inside DB

$a!Jan 30 2019 — edited Feb 1 2019

Hi All,

I have a schema that has multiple DB objects and elements like tables, sequences, triggers and even scheduled jobs etc.

Now I want to copy the entire schema(including the scheduled jobs and all) and paste it in another empty schema I created in the same DB.

Is it possible to copy the entire schema at a go?

If so, Please help me on how I can do it.

Please suggest.

Regards,

Sail

Added on Jan 30 2019

21 comments

31,465 views