Getting ORA-04042 Recreating CS Indexes With Cskbctxp.sql Script (Doc ID 342630.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 13-Jan-2014***


Symptoms

When attempting to run the cskbctxp.sql script to recreate CS indexes,
the following error occurs.


ERROR
$CS_TOP/patch/115/sql/cskbctxp.sql apps cs ctxsys
declare
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
ORA-06512: at "SYSTEM.AD_DDL", line 154
ORA-06512: at line 44

.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms