Unable to Run Collection Rebuild Because OracleText is Not Installed in Database
Last updated on DECEMBER 06, 2016
Applies to:Oracle WebCenter Content - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
The following message appears in CS native UI.
Tried rebuilding the collection, but received the following error message:
systemdatabase tracing revealed many "PLS-00201: identifier ... must be declared" messages for CTX_DDL.
systemdatabase/6 11.23 12:11:12.787 index rebuild work ORA-06550: line 1\, column 7:
systemdatabase/6 11.23 12:11:12.787 index rebuild work PL/SQL: Statement ignored
Logged into DB as dba and discovered that CTX_DDL didn't exist.
Received message "The object CTX_DDL does not exist "
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