FAQ 2005-04-24

How to use Oracle BFILE

eygle 2005-04-24 19:51

如何使用Oracle的BFILE
1.创建相应的directory
使用具有足够权限的用处创建directory,具体参考:Using Create directory & UTL_FILE in Oracle

create or replace directory BDUMP_DIR as 
'/opt/oracle/admin/conner/bdump';

2.给相应的用户授权



grant read on directory BDUMP_DIR  to eygle;

3.检查相应的文件是否存在



host ls -l /opt/oracle/admin/conner/bdump/alert_conner.log

4.数据操作



connect eygle/eygle
create table eygle_test (id number, bfiles bfile ); 

insert into eygle_test values ( 1, bfilename ( 'BDUMP_DIR', 'alert_conner.log' ) );

BFILENAME函数用法参考:
The Usage Of BFILENAME Function

操作日志:



SQL> connect / as sysdba
Connected.
SQL> grant read on directory BDUMP_DIR  to eygle; 

Grant succeeded.

SQL> connect eygle/eygle
Connected.
SQL> host ls -l /opt/oracle/admin/conner/bdump/alert_conner.log
-rw-r--r--    1 oracle   dba          1026 Apr 24 18:41 /opt/oracle/admin/conner/bdump/alert_conner.log

SQL> create table eygle_test (id number, bfiles bfile ); 

Table created.

SQL> insert into eygle_test values ( 1, bfilename ( 'BDUMP_DIR', 'alert_conner.log' ) );

1 row created.

SQL> commit;

Commit complete.

历史上的今天

2026-04-24 数据库一体机简史：从血脉相连到星火燎原的数据库革命
2020-04-24 Oracle 20c 新特性：表达式参数值 Expressions Parameter Values
2016-04-24 2016 ACOUG Asia Tour 济南站 - 花好月圆饮水泉城
2013-04-24 2013数据库大会:盖国强-Oracle优化器与算法案例解析
2011-04-24 2011年4月 ACOUG Exadata技术交流会
2008-04-24 peer.exe 进程是什么?
2006-04-24 如何为Oracle导出文件加上时间戳
2006-04-24 Oracle Fast-Start Fault Recovery选件

By eygle 2005-04-24 19:51 评论 (1)

eygle

前Oracle ACE Director，云和恩墨创始人。技术为骨，历史为脉，人文为魂。

返回首页 →

1 Comment

hadi santoso | June 17, 2005 4:41 PM

How to insert BFILE in oracle database?
How to run Multimedia File (BLOB) from oracle database, ORDSys.ORDAudio in visual basic 6.0?
Help Me please....1
Thanks