PLS-00201 ORA-06550 Error When Creating Index

Today, I get the next error when create a ne index (multimedia text kind);

02-MAR-17 14:45:47.812: ORA-39083: Object type INDEX:”ANR_SNAPSHOT”.”SEARCHER_CTX_I” failed to create with error:
ORA-06550: line 2, column 1:
PLS-00201: identifier ‘CTXSYS.DRIIMP’ must be declared

The problem here is CTXSYS schema is not created. I am not sure because of this schema dons’t exist. The unique solution is create it. You must run the Context catalog by execute de next like sys user;

sql> sta ?/rdbms/admin/catctx.sql

HTH – Antonio NAVARRO

 

Advertisements

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