The following DDL errors are observed when Post stopped due to error. However, no form of DDL replication is configured, meaning both SP_OCT_REPLICATE_ALL_DDL and SP_OCT_REPLICATE_DDL are set to 0.
Notice 2011-02-16 15:51:54.213000 4928 4920 s:2 Poster: ORA-02429: cannot drop index used for enforcement of unique/primary key. (posting from NAME1, queue queue_name, to NAME2) [module osp]
Error 2011-02-16 15:51:54.213000 4928 4920 s:2 Poster: Poster exit on 9i ddl error due to ORA-02429: cannot drop index used for enforcement of unique/primary key. on drop index OWNER.INDEX_NAME (posting from NAME1, queue queue_name, to NAME2) [module opo]
OR
Error 2011-02-12 06:24:34.587127 13392 3 s:2 Poster: Poster exit on 9i ddl error due to ORA-00955: name is already used by an existing object. on CREATE INDEX "OWNER.INDEX_NAME: ON "OWNER.TABLE_NAME" (posting from NAME1, queue queue_name, to NAME2) [module opo]
Notice 2011-02-12 06:24:34.586406 13392 3 s:2 Poster: ORA-00955: name is already used by an existing object. (posting from NAME1, queue queue_name, to NAME2) [module osp]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center