Skip to Main Content
Forums

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!

How to copy schema from one db to another with different schema name ?

User511360-OCJan 4 2018 — edited Jan 5 2018

Hi,

I want to use "Database Copy" of SQL Developer, and copy schema A from one db to schema B to another db. So, I created empty schema B, but got an error after choosing source schema:

"The selected schema A is/are not available on Destination database. Please create these schemas on destination before copy".

I can, of course, to create schema A, but I need it by another name in destination db!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 2 2018
Added on Jan 4 2018
#sql-developer
5 comments
2,727 views