Oracle技術之AWR匯入引發ORA-4031錯誤

嘗試在測試資料庫上匯入AWR資料，引發了ORA-4031錯誤。

錯誤資訊為：

SQL> @?/rdbms/admin/awrload

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Disclaimer: This SQL/Plus script. should only be called under

the guidance of Oracle Support.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~

AWR LOAD

~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~ This script. will load the AWR data from a dump file. The ~

~ script. will prompt users for the following information: ~

~ (1) name of directory object ~

~ (2) name of dump file ~

~ (3) staging schema name to load AWR data into ~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Specify the Directory Name

~~~~~~~~~~~~~~~~~~~~~~~~~~

Directory Name Directory Path

------------------------------ -------------------------------------------------

ADMIN_DIR C:\ADE\aime_10.2_nt_push\oracle/md/admin

AUDIT_DIR /tmp/

DATA_FILE_DIR E:\oracle\oracle1020\demo\schema\sales_history\

DATA_PUMP_DIR E:\oracle\admin\ytk102\dpdump\

D_AWR /data/backup

D_OUTPUT e:\dmp

D_OUTPUT1 E:\

LOG_FILE_DIR E:\oracle\oracle1020\demo\schema\log\

MEDIA_DIR E:\oracle\oracle1020\demo\schema\product_media\

SUBDIR E:\oracle\oracle1020\demo\schema\order_entry\/200

2/Sep

WORK_DIR C:\ADE\aime_10.2_nt_push\oracle/work

XMLDIR E:\oracle\oracle1020\demo\schema\order_entry\

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

Enter value for directory_name: D_AWR

Using the dump directory: D_AWR

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_1_47802

Loading from the file name: awrdat_1_47802.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 <return> 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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~