Previous Topic: Password ExpiryNext Topic: SQL Server Guidelines

Database Guide › Oracle Guidelines › Requirements for Oracle Import and Export Utilities

Requirements for Oracle Import and Export Utilities

(Applies only to export operations in Table Mode, User Mode or Tablespace Mode. If you run export operations in Full Database Mode, the following requirements do not apply.)

Oracle 11g Release 2 (11.2) and earlier ships with Import and Export utilities. The Export utility writes data from an Oracle database into an operating system file in binary format. This file is stored outside the database and it can be read into another Oracle database using the Import utility.

If you use the Import and Export utilities to move CA DataMinder data into a receptacle database where the objects were created by the native scripts, follow these steps:

  1. Drop the database sequences WGN3SEQ and Wgn3CpID before running the import operation.

    The native scripts create WGN3SEQ and Wgn3CpID. Drop these sequences before importing, otherwise these sequences are assigned default values instead of the source database values.

  2. Delete the values in the WgnID database table before running the import operation.

    The native scripts populate the table WGNID with default values. Delete these values before importing, otherwise the import results in duplicate key errors and the IDs are assigned default values instead of the source database values.

  3. Verify that all roles granted to CA DataMinder database accounts are enabled by default. This requirement applies to all Oracle users used by CA DataMinder and includes, for example, the Schema Owner, Primary User, and Search Users.
    1. After the import operation has completed, and before you start the CA DataMinder infrastructure, run the following command using the SQL*Plus utility: 
      ALTER USER <user_name> DEFAULT ROLE ALL;

      Where <user_name> is a CA DataMinder database account.

    2. Repeat this command for each CA DataMinder database account.

    Note: The Export utility only sets roles to be enabled by default if the export runs in Full Database Mode.

For more information on Oracle database utilities, please refer to your Oracle documentation.