awrload中的directory name是区分大小写的

最新推荐文章于 2022-03-30 16:27:31 发布

msdnchina

最新推荐文章于 2022-03-30 16:27:31 发布

阅读量566

点赞数

分类专栏： Oracle DB

本文链接：https://blog.csdn.net/msdnchina/article/details/53065027

版权

Oracle DB 专栏收录该内容

773 篇文章 3 订阅

订阅专栏

SQL> @?/rdbms/admin/awrload;
~~~~~~~~~~
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
------------------------------ -------------------------------------------------
A			       /data/161025awr_bak
B			       /data/161028new_awr
DATA_PUMP_DIR		       /home/oracle/app/oracle/admin/jt/dpdump/
ORACLE_OCM_CONFIG_DIR	       /home/oracle/app/oracle/product/11.2.0/dbhome_1/c
			       cr/hosts/localhost.localdomain/state

ORACLE_OCM_CONFIG_DIR2	       /home/oracle/app/oracle/product/11.2.0/dbhome_1/c
			       cr/state

XMLDIR			       /home/oracle/app/oracle/product/11.2.0/dbhome_1/r
			       dbms/xml

Directory Name		       Directory Path
------------------------------ -------------------------------------------------


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

Enter value for directory_name: a

Using the dump directory: a
declare
*
ERROR at line 1:
ORA-20103: directory name 'a' is invalid
ORA-06512: at line 17


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost 161025awr_bak]$