Logging into DAC for the First Time and Importing Metadata into the DAC Repository
4-48
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
5.
Select the Enable Batch Mode check box.
6.
Click OK to display the Importing tables dialog.
7.
To confirm that you want to import the seed data selected, re-type the text in the
text box and click Yes.
8.
If prompted to verify that you want to continue with the Import, click Yes.
When the process is complete, the DAC displays a status box containing a success
or failure message. If the process fails, use the DAC_HOME\dac\log\import.log
file to diagnose errors.
9.
Click OK.
Note:
If you are importing DAC metadata for the first time, you
should select the Truncate Repository Tables check box.
If you are importing DAC metadata into a repository that already has
metadata, do the following:
1.
Back up the current repository by exporting it to an empty directory (use
the 'Change import/export directory' button to select an empty directory.
2.
Use the 'Change import/export directory' button to select the
\dac\export\ directory.
3.
Select the Truncate Repository Tables check box and the Enable Batch
Mode check box, and import the new DAC metadata.
4.
Use the 'Change import/export directory' button to select the directory
where you backed up data in Step 1.
5.
Deselect the Truncate Repository Tables check box and re-import the data
you backed up.
Note:
If you are using an Oracle 9i Release 2 database, you cannot
use batch mode because the Oracle 9i JDBC drivers do not handle
array inserts or bulk inserts.
Note:
The import process typically takes between one and five
hours, depending on the location of the database that stores the DAC
Repository, the speed of the network, and the number of applications
selected in the Applications list on the Import dialog.