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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2012

Added on Apr 5 2012

5 comments

7,014 views