My Oracle Support Banner

ORA-25205 on Insert into a Replicated Table (Doc ID 100864.1)

Last updated on AUGUST 04, 2018

Applies to:

OracleDatabase - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

 Insert into a table that is part of a replicated group fails with the following error:

 

ORA-25205: the QUEUE system.def$_aqcall does not exist

 

Cause: The specified queue does not exist.

Action: Create the queue first before specifying it for enqueue or dequeue.

 

 

The queue is created by the script catdefrt.sql. Attempts to run that script and create the queue fail with the following error: ORA-24002: QUEUE_TABLE system.def$_aqcall does not exist Cause: Queue_table not exist.

Action: Query on the user view USER_QUEUE_TABLES to find out existing queue tables. However, a query of DBA_OBJECTS shows that the table does in fact exist. This database was created from a full export of a Master Database in a Replicated environment. The replication is not working on the new database.

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.