19.9 Transparent Read
DBFS Links can read from a linked SecureFiles LOB even if the data is not cached in the database.
You can read data from the content store where the data is currently stored and stream that data back to the user application as if it were being read from the SecureFiles LOB segment. This allows seamless access to the DBFS Linked data without the prerequisite first call to DBMS_LOB.COPY_FROM_DBFS_LINK()
.
Whether or not transparent read is available for a particular SecureFiles LOB is determined by the DBFS_CONTENT
store where the data resides. This feature is always enabled for DBFS_SFS
stores, and by default for DBFS_HS
stores. To disable transparent read for DBFS_HS
store, set the PROPNAME_STREAMABLE
parameter to FALSE
.
Parent topic: Database File System Links