Use the CREATE DIRECTORY statement to create a directory object. A directory object specifies an alias for a directory on the server's file system where external binary file LOBs (BFILEs) and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, thereby providing greater file management flexibility.All directories are created in a single namespace and are not owned by an individual's schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users.
Creating a Directory: Examples
The following statement creates a directory database object that points to a directory on the server:CREATE DIRECTORY admin AS 'oracle/admin';
The following statement redefines directory database object bfile_dir to enable access to BFILEs stored in the operating system directory /private1/lob/files:CREATE OR REPLACE DIRECTORY bfile_dir AS '/private1/LOB/files';
Creating a Directory: Examples
The following statement creates a directory database object that points to a directory on the server:CREATE DIRECTORY admin AS 'oracle/admin';
The following statement redefines directory database object bfile_dir to enable access to BFILEs stored in the operating system directory /private1/lob/files:CREATE OR REPLACE DIRECTORY bfile_dir AS '/private1/LOB/files';
解决方案 »
- 菜鸟问题:导出与还原的用户身份
- data guard如何恢复备库控制文件?
- 大家开发ebs画面(forms),用的是什么开发软件呢?
- 100分请教一下在oracle里有想sql-server里的dateadd这样的函数吗???
- 在oracle10中,要进行建表之类的操作是不是一定要安装client端??请各位给指跳道,在线========
- 我想将插入的数据字段value2的值移动到字段value1处 如何实现
- 请问,我在unix上用connect internal/oracle联接后,它总是报insufficient privileges,这是为什么?
- 有关oracle触发器的问题:在一个触发器中调用过程来关闭另一个触发器,怎么来实现这一目的,
- **請問這個小程序的結果是什麼??**
- ORA-01843: 无效的月份 有哪位大神知道怎么解决啊
- 请教复制记录的触发器??
- Oracle 数据库里默认的方案如SYSTEM中的数据表分别有怎样的作用?分不够再开新帖!
create directory一般用于此类目的
select name,phone_number from teacher_ext order by name
*
ERROR 位于第 1 行:
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-04063: unable to open log file
TEACHER_EXT_692_2016.log
OS error 系统找不到指定的文件。
ORA-06512: 在"SYS.ORACLE_LOADER", line 14
ORA-06512: 在line 1这些都是什么错误啊?恳求各位大哥指教,谢谢大家了先!!!
谢谢你的解释,但是您解释的没有解决我的问题,我建立好了表了,但是查询的时候错误如上,谁能解释一下啊?我该怎么做啊?