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!

In Cart is it possible to use a database connection to export schema objects from another database s

Marcel HoefsDec 12 2014

In SQLDev 4.0.3.16.84 I tried to export packages from one database schema to another in the same database using a third database user. This user has system privilege "select any data dictionary" so I can see the source of the packages I would like to export. I can add all the packages from the source schema and the owner column in cart shows the right object owner. Then when I try to export the contents of the cart to the destination database schema I see nothing. The log shows drop package statements for all the packages I try to export but creation of the packages is not happening.

What am I doing wrong?

Thank you for your help.

Marcel.

Comments

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

Post Details

Locked on Jan 9 2015
Added on Dec 12 2014
0 comments
587 views