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

最新推荐文章于 2024-03-16 08:28:34 发布

原创最新推荐文章于 2024-03-16 08:28:34 发布 · 618 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍了一个用于将AWR(Automatic Workload Repository)数据从转储文件加载到Oracle数据库的SQL*Plus脚本。该脚本会提示用户提供目录对象名称、转储文件名及目标模式等必要信息。示例中尝试使用名为'a'的目录对象时遇到了错误。

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]$