oracle查定义的目录,如何查看oracle中创建的所有目录

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>