ORA-06512: at “CTXSYS.TEXTINDEXMETHODS”, line 366

while creating a domain index as a SYS user for a table…..the following error was thrown:

ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-20000: Oracle Text error:

DRG-50857: oracle error in drvxtab.create_index_tables

ORA-01031: insufficient privileges

ORA-06512: at “CTXSYS.DRUE”, line 160

ORA-06512: at “CTXSYS.TEXTINDEXMETHODS”, line 366

 

Solution:

Grant create table to the schema account user of the table.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s