19 Database File System Links
Database File System Links enable storing SecureFiles LOBs in a different location than usual.
- About Database File System Links
DBFS Links allows storing SecureFiles LOBs transparently in a location separate from the segment where the LOB is normally stored. Instead, you store a link to the LOB in the segment. - Ways to Create Database File System Links
Database File System Links require the creation of a Database File System through the use of the DBFS Content package,DBMS_DBFS_CONTENT. - Database File System Links Copy
The APIDBMS_LOB.COPY_DBFS_LINK(DSTLOB,SRCLOB,FLAGS)provides the ability to copy a linked SecureFiles LOB. - The DBMS_LOB Package Used with DBFS
TheDBMS_LOBpackage provides subprograms to operate on, or access and manipulate specific parts of a LOB or complete LOBs. - DBMS_LOB Constants Used with DBFS
Certain constants support DBFS link interfaces. - DBMS_LOB Subprograms Used with DBFS
You should note that some changes have been made to theDBMS_LOBsubprograms over time. - Copying a Linked LOB Between Tables
You can copy DBFS links from source tables to destination tables. - Online Redefinition and DBFS Links
Online redefinition copies any DBFS Links that are stored in any SecureFiles LOBs in the table being redefined. - Transparent Read
DBFS Links can read from a linked SecureFiles LOB even if the data is not cached in the database.