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

Question

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

Answer 1

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)----------2SQL> select * from dba_directories;OWNER DIRECTORY_NAME------------------------------ ------------------------------DIRECTORY_PATH--------------------------------------------------------------------------------SYS DATA_PUMP_DIRD:\oracle\product\10.2.0\db_1\rdbms\log\SYS SSCFJSSCD:\his\data\ssc\fjSQL>