Forum Stats

  • 3,758,419 Users
  • 2,251,385 Discussions


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

Marcel Hoefs
Marcel Hoefs Member Posts: 29 Blue Ribbon

In SQLDev 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.


This discussion has been closed.