问个查询外部表的问题

显示全部楼层 · 2005-10-30 17:05:33

我用create directory 建立了一个目录，
我现在想知道这个目录是指向哪个具体物理的目录
不知道用哪个字典，那位老大帮帮忙！

千问 · 2005-10-30 17:05:33

Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as settle

SQL> select * from dba_directories;
OWNER
DIRECTORY_NAME
DIRECTORY_PATH
------------------------------ ------------------------------ --------------------------------------------------------------------------------
SYS
MEDIA_DIR
d:\oracle\ora9i\demo\schema\product_media\
SYS
LOG_FILE_DIR
d:\oracle\admin\settle\create\
SYS
DATA_FILE_DIR
d:\oracle\ora9i\demo\schema\sales_history\
SQL>

千问 · 2005-10-30 17:05:33

thank you!!!