Skip to Main Content

SQL Developer

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 a table and only the related indexes, constraints and sequences etc. associated to the table ov

StylesMay 8 2018 — edited May 16 2018

Hi Oracle Community members,

I would like to copy one table (SIMS_UNITS) and any and only indexes, constraints and sequences etc. associated to that one table (SIMS_UNITS) from schema (BTI) to another schema (BTEST) and I'm having trouble finding a solution for this.

I've tired the Database Copy option, selected the object however when executed the tool started copying over all the other sequences in the database too. I did not see the option to only copy associated constraints for the object selected if that even exists.

Any help would be appreciated.

Cheers,-K

This post has been answered by Styles on May 10 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2018
Added on May 8 2018
9 comments
5,433 views