Using the Load Data Database Tool

Load data

This database tool will load data from a DMP file into an OSM Database.

• The tool shows a set of steps that will be performed when loading data.

• The check boxes are not selectable but are used to indicate which steps that have been performed.

• The button in the lower right corner will change its name according to the different steps.

Requirements

The following conditions are required.

• The dump file must exist in the OSM data dump area defined as a directory on the Oracle server.

• The dump file can either be a full dump, schema dump, or just a data dump.

• The data in the dump file must be owned by the database user cow_owner.

• The tables must already exist in the OSM database. They will not be created.

• The file name (of the data pump) must not contain any spaces and the file extension will be set to .dmp if not given.

• The path to the OSM data pump area must not contain any spaces.

Guidelines

• Only data will be imported into the database. No other objects will be imported.

• The import will assume that either only one (1) table is to be imported or all tables are to be imported.

  Steps

The steps to load data into an OSM database.

Step 1. Set data pump area

This step will set the OSM Data Pump Area to a given path. The path must exist on the Oracle server.

1. Enter the path to the data pump area.

2. (Optional) Select the Use default path check box to set the recommended default path for the OSM data pump area.

   or

3. (Optional) Click Get current area to use the current path.

4. Click Set.

   

Step 2. Enter DMP file

This step sets the name of the DMP file. The dump file must exist in the OSM Data Pump Area.

5. Enter the file name of the data pump file.

6. (Optional) Select the Use OSM default data dump file check box to set the default file name for the OSM data pump file.

7. Click Add.

   

Step 3. All tables or one table

This step specifies whether only ONE table should be imported or all tables should be imported.

If all tables are to be imported, then the application assumes that all tables owned by cow_owner are to be imported.

There is one exception regarding importing data. No licence information will be imported.

8. Select either Import data into all tables or Import data into ONE table.

9. Click Apply.

   

Step 4. Validate dump file

This step will validate the existence and other information regarding the dump file.

10. Click Validate.

11. If successful, you will see a message at the bottom of the screen.

    

    If not successful, you will get a dialog box message.

    

Step 5. Disable triggers and constraints

This step will disable all triggers and constraints so that data can be imported.

12. Click Disable.

    

    When finished, you will see a message at the bottom of the screen.

    

Step 6. Load

This step will start a job that will load the data.

13. Click Load.

    

14. When finished, you will see a dialog box informing you of success. Click OK.

    

Step 7. Enable triggers and constraints

This step will enable all triggers and constraints so that data can be validated (consistency check).

15. Click Enable.

    

    When finished, you will see a message at the bottom of the screen.

    

16. Click Finish to close the tool.

After performing this operation, remember to Run OSM Privileges.