Installing Export Files from SQL Command Line

You can also install export files from SQL Command Line (SQL*Plus). Note there are two restrictions:

The export file must originate from the same user database account as the one into which you are installing.
If the export file is an application, the application ID will be overwritten. Therefore, the target workspace must own the ID of the application being installed.

Topics:

Verifying If Source and Target Workspace IDs Are Identical

You can verify that the source and target database user accounts are identical by running query in SQL Command Processor.

To verify that the source and target database user accounts are identical:

Log in to the source workspace.
Click the SQL icon on the Database Home Page.
Click SQL Commands.
Enter the following in the SQL editor pane and click Run.
```
SELECT &WORKSPACE_ID. FROM DUAL
```
Make note of workspace ID.
Log in to the target workspace.
Repeat steps 2 through 5 to verify the workspace IDs match.

To install Oracle Application Express export files from SQL Command Line (SQL*Plus):

Log in to SQL Command Line using your Oracle Application Express database user account.
Run the export file.

For example, if your export file is names f144.sql by default, you would type @f144 at the command prompt.