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




Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s