Specify the Directory Name
~~~~~~~~~~~~~~~~~~~~~~~~~~

Directory Name Directory Path
------------------------------ -------------------------------------------------
AGREE_AWRREPORT_DIR /tmp/xunjian
DATA_PUMP_DIR /u01/app/oracle/admin/orcl/dpdump/
EXPDP /arch/expdp <<<<<<<<<<<<<<<<<<<<<<
ORA10G_PUMP /u01/app/oracle/datapump/ora10g
ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/11.2.0/db_1/ccr/state
XMLDIR /u01/app/oracle/product/11.2.0/db_1/rdbms/xml

Choose a Directory Name from the list above (case-sensitive).

Enter value for directory_name: EXPDP <<<<<<<<<<<<<<<<输入DIRECTORY名称
Using the dump directory: EXPDP

Specify the Name of the Dump File to Load
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please specify the prefix of the dump file (.dmp) to load:

Enter value for file_name: awrdat_4707_4708 <<<<<<<<<<<<<<<输入文件名(不包含后缀.dmp)

Loading from the file name: awrdat_4707_4708.dmp

Staging Schema to Load AWR Snapshot Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The next step is to create the staging schema
where the AWR snapshot data will be loaded.
After loading the data into the staging schema,
the data will be transferred into the AWR tables
in the SYS schema.

The default staging schema name is AWR_STAGE.
To use this name, press to continue, otherwise enter
an alternative.

Enter value for schema_name: <<<<<<<<<<<<<<回车,取默认值

Using the staging schema name: AWR_STAGE

Choose the Default tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE users's default tablespace. This is the
tablespace in which the AWR data will be staged.

TABLESPACE_NAME
--------------------------------------------------------------------------------
CONTENTS DEFAULT TABLESPACE
--------------------------- ------------------
SYSAUX
PERMANENT *

USERS
PERMANENT

Pressing will result in the recommended default
tablespace (identified by *) being used.

Enter value for default_tablespace: <<<<<<<<<<<<<回车,取默认值

Using tablespace SYSAUX as the default tablespace for the AWR_STAGE

Choose the Temporary tablespace for the AWR_STAGE user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Choose the AWR_STAGE user's temporary tablespace.

TABLESPACE_NAME
--------------------------------------------------------------------------------
CONTENTS DEFAULT TEMP TABLESPACE
--------------------------- -----------------------
TEMP
TEMPORARY *

Pressing will result in the database's default temporary
tablespace (identified by *) being used.

Enter value for temporary_tablespace: <<<<<<<<<<<<<回车,取默认值

Using tablespace TEMP as the temporary tablespace for AWR_STAGE

... Creating AWR_STAGE user

|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
| /arch/expdp
| awrdat_4707_4708.dmp
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Load Started ...
|
| This operation will take a few moments. The
| progress of the AWR load operation can be
| monitored in the following directory/file:
| /arch/expdp
| awrdat_4707_4708.log
|
...