Installing Export Files from SQL*Plus

You can also install export files from 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.
If the export file contains Supporting Object scripts, the scripts are not run when the application is installed. You can either log in to the Application Builder to install Supporting Objects, or copy the installation scripts to a standalone SQL*Plus script and run them from there.

Topics:

Verifying If Source and Target Workspace IDs Are Identical

You can verify that the source and target workspaces are identical by running a query in SQL Command Processor.

To verify that the source and target workspaces are identical:

Log in to the source workspace.
Click the SQL Workshop icon on the Workspace home page.
Click SQL Commands.
Enter the following in the SQL editor pane and click Run:
```
SELECT &WORKSPACE_ID. FROM DUAL
```
Note the 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*Plus:

Log in to SQL*Plus.
Run the export file.

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