如何使用Oracle的BFILE(1)

文章作者 100test 发表时间 2007:03:14 13:51:51
来源 100Test.Com百考试题网

何使用oracle的bfile
1.创建相应的directory
使用具有足够权限的用处创建directory,具体参考:using create directory &. utl_file in oracle
create or replace directory bfile_dir as
’/home/oracle/bfiletest’.
[oracle@ts01 bfiletest]$ sqlplus ’/ as sysdba’
sql*plus: release 9.2.0.6.0 - production on mon jan 23 10:54:17 2006{HF8TE],v 0ux *oV[本资料来源于贵州学习网 http://www.gzu521.com]{HF8TE],v 0ux *oV
copyright (c) 1982, 2002, oracle corporation. all rights reserved.
connected to:
oracle9i enterprise edition release 9.2.0.6.0 - production
with the partitioning, olap and oracle data mining options
jserver release 9.2.0.6.0 - production
sql> show parameter utl_file_dir ***************9.2开始，已经废弃了这个参数
name type value
------------------------------------ ----------- ------------------------------
utl_file_dir string
sql>
sql> create or replace directory bfile_dir as
2 ’/home/oracle/bfiletest’.
directory created.
elapsed: 00:00:00.05
sql>
sql> col directory_path for a50
sql> 0select * from dba_directories.
owner directory_name directory_path
------------------------------ ------------------------------ --------------------------------------------------
sys media_dir /oracle/product/920/demo/schema/product_media/
sys log_file_dir /oracle/admin/tsmisc02/create/
sys data_file_dir /oracle/product/920/demo/schema/sales_history/
sys ku$_stylesheet_dir /oracle/product/920/rdbms/xml/xsl
sys bfile_dir /home/oracle/bfiletest
elapsed: 00:00:00.01
sql>