|
Re: APEX 4.0 IMPORT does not copy PL/SQL PACKAGE [message #651225 is a reply to message #651224] |
Fri, 13 May 2016 04:18 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
When you create an Apex application, you do that in Apex' workspace. During workspace creation, you have to assign an Oracle schema to it. Packages belong to that Oracle user (schema), not an Apex application. Therefore, if you are moving that Apex application somewhere else, you export it (which is what you already did). However, you have to export tables, views, procedures, packages, ... using Oracle Export Data Pump utility (EXPDP) (or Export, EXP, depending on your database version).
On a new system, you have to create a new Oracle user and import the dump file (EXPDP exports it, IMPDP imports it). Once you have it done, you can import the Apex application as well (of course, if you have previously created a new workspace and assigned the newly create Oracle user to it).
|
|
|