ORA-00942 When Creating A Trigger (Doc ID 1052895.1)

Last updated on JANUARY 27, 2010

Applies to:

Oracle Database Vault - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms


Ora-942 occurs when creating a trigger. Example:

SQL> CREATE OR REPLACE TRIGGER SRE.UUID_AS_PK_TRIGGER BEFORE INSERT ON
SRE.WICU_REQUEST
FOR EACH ROW
begin
select SRE.UUID_SEQUENCE.nextval into :new.uuid from dual;
end;
/
SRE.WICU_REQUEST
*
ERROR at line 2:
ORA-00942: table or view does not exist

When analyzing the problem you find the ora-942 occurs on the following recursive statement:

select 1 FROM dvsys.realm_object$ WHERE owner =:1 and object_name =:2 and object_type =:3

Then you find out that table dvsys.realm_object$ does indeed not exist.

Changes

The Database Vault option was installed in the Oracle Home but not registered within the database with  DBCA.

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