Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » APEX 4.0 IMPORT does not copy PL/SQL PACKAGE
APEX 4.0 IMPORT does not copy PL/SQL PACKAGE [message #651224] Fri, 13 May 2016 03:05 Go to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi

I have imported my application, but Package are not imported ?
It's an separate option, or an Separate Importation ?

Regards
Philippe
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 Go to previous message
Littlefoot
Messages: 21562
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).
Previous Topic: IMPORT APPLICATION 555 to 101 why
Next Topic: Classic Report- Sum based on Condition
Goto Forum:
  


Current Time: Tue Jun 02 20:21:23 CDT 2020