Previous
Previous
 
Next
Next

Installing Export Files from SQL*Plus

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

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:

  1. Log in to the source workspace.

  2. Click the SQL Workshop icon on the Workspace home page.

  3. Click SQL Commands.

  4. Enter the following in the SQL editor pane and click Run:

    SELECT &WORKSPACE_ID. FROM DUAL
    
  5. Note the workspace ID.

  6. Log in to the target workspace.

  7. Repeat steps 2 through 5 to verify the workspace IDs match.

Using SQL*Plus to Install Export Files

To install Oracle Application Express export files from SQL*Plus:

  1. Log in to SQL*Plus.

  2. Run the export file.

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