My Oracle Support Banner

ORA-924 When Using DBMS_REPCAT_RGT.INSTANTIATE_ONLINE (Doc ID 104979.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.6.0 and later
Information in this document applies to any platform.

Symptoms

When instantiating a deployment template calling the DBMS_REPCAT_RGT.
INSTANTIATE_ONLINE function, the following error is raised :

ORA-942: table or view does not exist


A SQL trace output shows the error is occurring while attempting to insert into
the table SYSTEM.REPCAT$_TEMP_OUTPUT.

'PARSE ERROR #23:len=87 dep=1 uid=0 oct=2 lid=0 tim=2005174224 err=942
INSERT INTO system.repcat$_temp_output (output_id, line, text) VALUES ...
EXEC #1:c=2834076,e=2894000,p=0,cr=168,cu=88,mis=0,r=0,dep=0,og=4,tim=...
ERROR #1:err=942 tim=2777500'



Note: A sql trace output can be generated by issuing:
'ALTER SESSION SET SQL_TRACE = TRUE;'

before the failing instantiation of a deployment template

Changes

{CHANGE}

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.