本文详细介绍了 BFILE 数据类型，这是一种用于存储操作系统文件中外置的非结构化二进制数据的数据类型。BFILE 支持最大 8TB 的数据存储，并且只允许随机读取而非顺序读取，不参与事务操作。文章还强调了数据库管理员确保文件存在及其 Oracle 进程拥有读权限的重要性。
BFILE Datatype
The<wbr> BFILE datatype stores unstruct ured binary data in oper ating-system files outside<br> the database. A BFILE column or attribute stores a file locator that points to an<br> external file containing the data.<wbr> BFILEs can store up to 8 terabytes of data.<br> BFILEs are read only; you cannot modify them. They support only random (not<br> sequential) reads, and they do not participate in transactions. The underlying<br> operating system must maintain the file integrity, security, and durability for<wbr> BFILE s.<br> The database administrator must ensure that the file exists and that Oracle processes<br> have operating-system read permissions on the file. </wbr></wbr></wbr>
The<wbr> BFILE datatype stores unstruct ured binary data in oper ating-system files outside<br> the database. A BFILE column or attribute stores a file locator that points to an<br> external file containing the data.<wbr> BFILEs can store up to 8 terabytes of data.<br> BFILEs are read only; you cannot modify them. They support only random (not<br> sequential) reads, and they do not participate in transactions. The underlying<br> operating system must maintain the file integrity, security, and durability for<wbr> BFILE s.<br> The database administrator must ensure that the file exists and that Oracle processes<br> have operating-system read permissions on the file. </wbr></wbr></wbr>
扫一扫
180
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
