Compiling TMS_ACTIVATION_LOCK Fails With ORA-00942 (Doc ID 2274563.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Thesaurus Management System - Version 5.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to compile TMS_ACTIVATION_LOCK by running the tmspb_activation_lock.plb script the following error occurs.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY TMS_ACTIVATION_LOCK:

LINE/COL ERROR
-------- ------------------------------------------------------
15/7 PL/SQL: SQL Statement ignored
20/18 PL/SQL: ORA-00942: table or view does not exist

Changes

Recently migrated and upgraded database from 4.6.x to 5.1.0 using Export/Import

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