Awrload导入数据报ORA | 您所在的位置:网站首页 › ora06512解决方法 › Awrload导入数据报ORA |
SQL> @?/rdbms/admin/awrload.sql ~~~~~~~~~~ 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 ------------------------------ ------------------------------------------------- IMPDP_DIR_2 /u01/expdp_dir
Choose a Directory Name from the list above (case-sensitive).
Enter value for directory_name: IMPDP_DIR_2
Using the dump directory: IMPDP_DIR_2
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: sbd_39791_39978
Loading from the file name: sbd_39791_39978.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 declare * ERROR at line 1: ORA-20104: schema name ‘AWR_STAGE‘ already exists ORA-06512: at line 17
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning option |
CopyRight 2018-2019 实验室设备网 版权所有 |