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!

How to copy all tables, triggers, etc from one user schema to another

847831Mar 16 2011 — edited Mar 16 2011

Hello everybody!

I am searching for a QUERY or Stored Procedure to copy the tables of one user schema to another schema.

Should look kind of: Copy (Select * from all_objects where owner = 'UserIwantToCopyFrom') to user = 'UserIwantToCopyTO'

I am sure that my example is rubbish but I tried to explain what I want to do.

So is there a chance to do that within sql-code? I have to build a template of a user schema with hundreds of tables, triggers, etc and copy it to several other user schemas.

Thanks for your advice!

Jan

This post has been answered by 727876 on Mar 16 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2011

Added on Mar 16 2011

#general-database-discussions

5 comments

1,377 views