oracle bfile

11g
External LOBs A BFILE(binary file LOB) is an external LOB becausethe database
stores a pointer to a file in the operating system. The externaldata is read-only.
A BFILEuses a directory object to locate data. The amount of spaceconsumed
depends on the length of the directory object name and the lengthof the file name.
A BFILEdoes not use the same read consistency mechanism as internalLOBS because
the binary file is external to the database. If the data in thefile changes, then repeated reads from the same binary file mayproduce different results.

10g
用户可以使用 BFILE 数据类型在数据库外的操作系统文件中存储二进制数据。
数据类型为 BFILE 的列或属性中存储的为文件定位器[file locator]，其指向
包含实际数据的外部文件。BFILE 数据类型最大可存储 8 TB 数据。

BFILE 数据是只读的，用户不能对其修改。BFILE 数据只支持随机读取（不支
持顺序读取），且不支持事务控制。底层操作系统必须负责确保 BFILE 文件的
完整性，安全性，及持久性[durability]。数据库管理员应确保所有 BFILE 文
件存在，且 Oracle 进程具有读取 BFILE 文件的操作系统权限。



from metalink:
 

ORA-01652 TemporarySegment       ===========================        
 SELECT  next_extent,pct_increase,tablespace_name       FROM   dba_tablespaces       WHERE   tablespace_name ='';           
 Temporary  segments take thedefault storage clause of thetablespace         in which they arecreated.      

If this error is caused by a query, then try and ensure that thequery       is tuned to perform its sorts as efficiently aspossible.     
 
  To find the owner of a sort, please refer to[NOTE:1069041.6]