我认为这个信息在Oracle元数据表中可用,但是在哪里呢?
我需要BFILENAME的目录对象,如这个答案:Using PL/SQL how do you I get a file’s contents in to a blob?
我试过了:
- select * from all_objects where object_type ='DIRECTORY';
- OWNER OBJECT_NAME
- ------------------------------ ------------------------------
- SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
- ------------------------------ ---------- -------------- -------------------
- CREATED LAST_DDL_TIME TIMESTAMP STATUS T G S
- ------------------- ------------------- ------------------- ------- - - -
- NAMESPACE EDITION_NAME
- ---------- ------------------------------
- SYS ORACLE_OCM_CONFIG_DIR
- 12689 DIRECTORY
- 2010-03-30 10:16:30 2011-01-10 12:49:39 2011-01-10:12:49:39 VALID N N N
- 9
- SYS DATA_PUMP_DIR
- 12764 DIRECTORY
- 2010-03-30 10:16:43 2011-01-10 12:49:38 2011-01-10:12:49:38 VALID N N N
- 9
- SYS XMLDIR
- 57134 DIRECTORY
- 2010-03-30 10:29:37 2010-03-30 10:29:37 2010-03-30:10:29:37 VALID N N N
- 9
ALL_DIRECTORIES数据字典视图将具有有关您可以访问的所有目录的信息。这包括操作系统路径
- SELECT owner,directory_name,directory_path
- FROM all_directories