How to use Oracle BFILE

« The Usage Of BFILENAME Function | Blog首页 | 使用SQL*PLUS,构建完美excel或html输出 »

How to use Oracle BFILE

作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2005/04/how_to_use_orac.html

站内相关文章|Related Articles

如何使用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.

-----
这篇【How to use Oracle BFILE】来自 www.eygle.com | CSDN技术网摘| del.icio.us|365Key

By eygle on 2005-04-24 19:51 | Comments (1) | Posted to FAQ | Edit |Pageviews:

相关文章	随机文章
	中国移动之心-谁与争锋 Oracle诊断案例-Job任务停止执行 Oracle10gR2 New Feature:V$SESSION change tracking 你从哪里来,我的朋友? 尝试阿里妈妈平台销售首页广告位

网上相关主题:

留言 (1)

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

Posted by: hadi santoso at June 17, 2005 4:41 PM

www.eygle.com

How to use Oracle BFILE

留言 (1)

发表留言: