
|
-
In the navigation pad, select Administration >
Import an Explore Database.
You are prompted to enter the passwords.
-
Enter the passwords, and then click OK.
The Import an Explore Database window appears.
-
Database export of CES is available in the form of a
dump (SDMGOLD.dmp) file under the "<OS>_a/resources/sdm/sdmdb/oracle"
directory, where OS refers to distribution for given Operating
System (e.g.: For windows, it is intel and aix for IBM AIX).
This dump file needs to be imported into the newly created database.
This table explains fields displayed in the Import
an Explore Database window:
ORACLE_SID
|
The ORACLE_SID
of the database being imported
|
NLS_LANG
|
This parameter sets the language, territory
and character set used by the database for both the server session
and the client application. The default value displayed here
is based on the entry specified in the Database Setup
window, and can be changed.
|
Import File
|
This is the file (database dump) from which
the data is imported.
|
Log File
|
Name of the file on which the import status
is to be written.
|
Import Mode
|
Entire Database
CISDBA Schema
Table
|
Buffer Size
|
This parameter determines the size of the buffer
used to transfer the data from the export dump to the database.
The import will be faster if bigger buffer size is given. The
memory for the buffer is taken from the operating system. This
parameter is an editable field and defaulted to 1 MB. The UOM
for this parameter is KB and MB.
|
Commit
|
This indicates the import utility how often
the imported data should be reported. If commit=n, the data
is committed after each table. If commit=y, the data is committed
after each buffer.
|
Ignore
|
This parameter decides whether the object creation
errors should be reported. If set to ignore=y, the object creation
errors will not be shown in the import log file/EDM
status window.
|
Statistics
|
This determines if optimizer statistics (if
existing in the export dump) should be loaded into the database
or not. The available options are NONE, ALWAYS, RECALCULATE
and SAFE.
|
-
Click Import to start the import process.
The bottom panel indicates the progress and when the database import
is successfully completed.
-
Click Cancel to return to the EDM
main menu.
You can check the Log File to see the import status.
If your import mode is CISDBA Schema or Table, you are prompted whether
you want to split the import. The following two choices are provided.
Select any one of the preceding and click
OK.
-
If you select Import Data and Indexes together,
EDM imports everything together.
-
If you select Import Data then create indexes,
EDM imports in three steps process:
Generate the index-creation statements in the script
${EDS_HOME}/log/imp_cr_indexes_<ORACLE_SID>_<TIMESTAMP>.sql
for UNIX , and %EDS_HOME%\log\imp_cr_indexes_%ORACLE_SID%_<TIMESTAMP>.sql
for Windows.
If any error occurs while generating the script, the import
process is aborted with the error message.
-
Import the data. Run the script generated by step 1
to create the indexes.
|