查询oracle所有的目录,Oracle命令--如何查看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