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 184.108.40.206 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Insert into a table that is part of a replicated group fails with the following error:
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!