Loading Foreign Objects into Oracle

System Administrators can use the procedure below to load adapted data into a 3DSpace Oracle database.

Before you begin: Back up your system before executing loader.bat.
  1. Create any new 3DSpace local vaults to hold the newly-loaded objects. You can also use existing vaults.
  2. Create the load files by invoking SqlLdr with the following MQL command: 

    export vault SOURCE into vault DESTINATION[{,DESTINATION1}];

    Where:

    • SOURCE is the foreign vault on which SqlLdr is to operate.
    • DESTINATION is a comma-separated list of the name of the 3DSpace local vault into which the data is to be loaded. If more than one vault is listed, a round-robin algorithm is used by default when loading the data, unless you added vault statements in Step 2.

    This command creates a series of files in the default directory in which MQL is running:

    • .ctl Oracle control files
    • loader.bat to invoke the Oracle SqlLdr utility across all the data and control files

  3. Modify the loader.bat file. Open this file in a text editor and make the following changes:

    • Check the version of the SqlLdr tool specified. Version 80 is the default. If you use Oracle 8.1 and run the bat file on NT, for example, change sqlldr80 to sqlldr81. On UNIX, change sqlldr80 to sqlldr.
    • Change USER and PASS to the Oracle user name and password the SqlLdr utility uses to connect to Oracle. USER and PASS will typically be the same as the username and password in the 3DSpace bootstrap file.

  4. Execute loader.bat.
  5. Check the default directory for files named *.bad. These files describe any problems encountered during the migration.