DIRECTORY_DATASTORE

Use the DIRECTORY_DATASTORE type during indexing to access the text stored in files which can be accessed through Oracle directory objects.

Starting with Oracle Database 19c, the Oracle Text type FILE_DATASTORE is deprecated. Use DIRECTORY_DATASTORE instead.

Oracle recommends that you replace FILE_DATASTORE text indexes with the DIRECTORY_DATASTORE index type, which is available starting with Oracle Database 19c. DIRECTORY_DATASTORE provides greater security because it enables file access to be based on directory objects.

A directory object specifies an alias for a directory on the server file system where external binary file LOBs (BFILEs) and external table data are located. When you use DIRECTORY_DATASTORE type, another PDB user can not access directory objects in your PDB without read access to the directory objects.

Use the DIRECTORY_DATASTORE type to use an Oracle directory object as an attribute for the CTX_DDL.SET_ATTRIBUTE procedure. You must have read access to the Oracle directory object to access the files stored within the directory. If you have access, then during index creation, you can use the path stored in the Oracle directory object to access the files stored in the file system.

• DIRECTORY_DATASTORE Attributes

• DIRECTORY_DATASTORE Example

Note:

To create an Oracle directory object, you must have the CREATE ANY DIRECTORY privilege. Typically, a system administrator user creates the directory and provides read access to the directory for an Oracle Text user. DIRECTORY_DATASTORE can be used with a context index on CHAR datatype column only if the file name fills the column.