示例說明:
SQL> conn / as sysdba
已連線。
SQL> create directory sscFjSsc as "D:\his\data\ssc\fj";
目錄已建立。
SQL> desc dba_directories
名稱 是否為空? 型別
OWNER NOT NULL VARCHAR2(30)
DIRECTORY_NAME NOT NULL VARCHAR2(30)
DIRECTORY_PATH VARCHAR2(4000)
SQL> select count(1) from dba_directories;
COUNT(1)
----------
2
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS DATA_PUMP_DIR
D:\oracle\product\10.2.0\db_1\rdbms\log\
SYS SSCFJSSC
D:\his\data\ssc\fj
示例說明:
SQL> conn / as sysdba
已連線。
SQL> create directory sscFjSsc as "D:\his\data\ssc\fj";
目錄已建立。
SQL> desc dba_directories
名稱 是否為空? 型別
OWNER NOT NULL VARCHAR2(30)
DIRECTORY_NAME NOT NULL VARCHAR2(30)
DIRECTORY_PATH VARCHAR2(4000)
SQL> select count(1) from dba_directories;
COUNT(1)
----------
2
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS DATA_PUMP_DIR
D:\oracle\product\10.2.0\db_1\rdbms\log\
SYS SSCFJSSC
D:\his\data\ssc\fj