|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
There are two ways to install export files:
Import the export files into Application Builder and then install the files from the Export Repository
Install the export files from SQL*Plus
Topics:
After you import files into the target Oracle HTML DB instance, you must install them before they can become active or available in Application Builder.
To install files stored in the Export Repository:
Navigate to the Workspace home page.
Click the Application Builder icon.
Select an application.
On the Application Builder home page, click Export/Import.
Select View Repository on the bottom of the page.
Select the file to be installed and click Install in the Action column adjacent to the appropriate file.
From Parse As Schema, select a schema.
This is the schema against which all of the application's SQL and PL/SQL will be parsed.
From Build Status, select one of the following:
Run Application Only
Run and Build Application
Select Run Application Only to run the application in the target instance, but make it inaccessible to developers. See "Changing Application Build Status" .
From Install As Application, select one of the following:
Reuse Application ID from Export File
Auto Assign New Application ID
Change Application ID
Use these options to avoid application ID conflicts. These options come in handy when you need to have two versions of the same application in the same instance. For example, you might be migrating an application to a production instance, but still need to maintain development version.
Click Install Application.
In addition to installing files, you can also use this page to delete a file from the Export Repository.
To delete a file from the Export Repository:
Navigate to the Export Repository.
Select the file to be deleted Delete Checked.
You can also install export files from SQL*Plus. Note there are two restrictions:
The export file must originate from the same workspace 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:
You can verify that the source and target workspace IDs are identical by running query in SQL Command Processor.
To verify that the source and target workspace IDs 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
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 HTML DB export files from SQL*Plus:
Log in to SQL*Plus as a user account that has access to your workspace (in other words, the workspace has been mapped to the schema).
Run the export file.
For example, if your export file is names f144.sql by default, you would type @f144 at the command prompt.