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

 

 

转载于:https://www.cnblogs.com/freshbreeze/archive/2013/05/30/3111088.html