Index owner does not have the privilege to use file or URL datastore Cause.
When you tried to create an index, if the index owner does not have the privilege to use file or URL datastore, it will occur the following error stack:
IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "FILES_CONTENT_IDX" ON "FILES" ("CONTENT_URL" ) INDEXTYPE IS " ""CTXSYS"."CONTEXT" PARAMETERS ('DATASTORE CTXSYS.FILES_CONTENT_PREF FILTER " "CTXSYS.INSO_FILTER LEXER CTXSYS.ATTACHMENT_LEXER STORAGE CTXSYS.FILES_CONTE" "NT_STORAGE ')" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10758: index owner does not have the privilege to use file or URL datastore
Index owner does not have the role defined in FILE_ACCESS_ROLE.
Grant index owner the appropriate role
To determine if the ability to use an Oracle Text URL datastore is already granted to a database role:
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password *
On UNIX and Linux:
$ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
If you executed above steps and still got this error,You probably need to grant “admin” and “default” privileges on Apex_Url_Datastore_Role for this particular user APEX_040000.