Error DRG-10758 When Creating Text Index Using File or URL Datastore

Error DRG-10758 When Creating Text Index Using File or URL Datastore

Error:

When trying to creating a Text index using a file or URL datastore, it may fail with the error DRG-10758: index owner does not have the privilege to use file or URL datastore, see below:

begin

  ctx_ddl.create_preference('COMMON_DIR','FILE_DATASTORE');

end;

/

create index doc_index on documents (filename)

indextype is ctxsys.context

parameters ('DATASTORE COMMON_DIR');

*

ERROR at line 1:

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

ORA-06512: at "CTXSYS.DRUE", line 160

ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

Solution:

To change file_access_role, you must be connected as SYSDBA.

SQL> connect as sysdba

SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public')

If you like please follow and comment