Skip to Main Content

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!

Copy data from one schema to another schema tables

Sudhir_MeruApr 5 2012 — edited Apr 5 2012
Hi,

I was doing a copy using sql developer copy feature, data copy worked perfect but for few table data didn't move there are about 30 tables from schema prod to schema dev i need to move tables are already created only data needs to be moved from prod to dev

Can you suggest me any method were I can move all the tables data at a time from one schema to another. Please suggest.

Thanks
Sudhir
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2012
Added on Apr 5 2012
5 comments
7,014 views