An attempt to import awr data on the test database caused a ORA-4031 error.
The error message is:
Sql> @?/rdbms/admin/awrload
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer:this sql/plus script. should be called under
The guidance of Oracle Support.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~
AWR LOAD
~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ this script. Would load the AWR data from a dump file. The ~
~ Script. Would 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 are to create the staging schema
Where the AWR snapshot data would be loaded.
After loading the data into the staging schema,
The data is 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~