Database Software

We have this issue on our 10.2.0.4 (Windows Server 2003 x64) Logical Standby Database where the following command was skipped:

CREATE OR REPLACE PUBLIC SYNONYM TRANSFER_REQUEST FOR TRANSFER_REQUEST;

This was ran as the CSPANOWNER schema.

On looking into the issue i found the entry in dba_logstdby_events that it skipped the command...

ORA-16205: DDL skipped due to skip setting

What is strange is that our skip settings do not tell the standby to skip this ddl. Unless I'm missing something?

Thanks
Graeme

p.s here are our skip settings from the

SELECT * FROM DBA_LOGSTDBY_SKIP;
N SCHEMA_DDL DISCEUL % Y
N DML DISCEUL % Y
N SCHEMA_DDL DW_CDC % Y
N DML DW_CDC % Y
N SCHEMA_DDL AUD$_ARCHIVE % Y
N DML AUD$_ARCHIVE % Y
N DML % AUD$ Y
N PROCEDURE NUMA % Y
N SEQUENCE NUMA % Y
N SYNONYM NUMA % Y
N PROFILE NUMA % Y
N ROLE NUMA % Y
N ROLLBACK STATEMENT NUMA % Y
N TABLE NUMA % Y
N VIEW NUMA % Y
N DML LSPENCER % Y
N TRIGGER NUMA % Y
N TYPE NUMA % Y
N INDEX LSPENCER % Y
N DML GCHANDR1 % Y
N INDEX GCHANDR1 % Y
N PROCEDURE GCHANDR1 % Y
N PROFILE GCHANDR1 % Y
N ROLE GCHANDR1 % Y
N ROLLBACK STATEMENT GCHANDR1 % Y
N SEQUENCE GCHANDR1 % Y
N SYNONYM GCHANDR1 % Y
N TABLE GCHANDR1 % Y
N TRIGGER GCHANDR1 % Y
N TYPE GCHANDR1 % Y
N VIEW GCHANDR1 % Y
N DML MRYON % Y
N INDEX MRYON % Y
N PROCEDURE MRYON % Y
N PROFILE MRYON % Y
N ROLE MRYON % Y
N ROLLBACK STATEMENT MRYON % Y
N SEQUENCE MRYON % Y
N SYNONYM MRYON % Y
N TABLE MRYON % Y
N TRIGGER MRYON % Y
N TYPE MRYON % Y
N VIEW MRYON % Y
N PROCEDURE LSPENCER % Y
N SEQUENCE LSPENCER % Y
N SYNONYM LSPENCER % Y
N PROFILE LSPENCER % Y
N ROLE LSPENCER % Y
N ROLLBACK STATEMENT LSPENCER % Y
N TABLE LSPENCER % Y
N VIEW LSPENCER % Y
N DML CKARI % Y
N TRIGGER LSPENCER % Y
N TYPE LSPENCER % Y
N INDEX CKARI % Y
N DML DCOHEN % Y
N INDEX DCOHEN % Y
N PROCEDURE DCOHEN % Y
N PROFILE DCOHEN % Y
N ROLE DCOHEN % Y
N ROLLBACK STATEMENT DCOHEN % Y
N SEQUENCE DCOHEN % Y
N SYNONYM DCOHEN % Y
N TABLE DCOHEN % Y
N TRIGGER DCOHEN % Y
N TYPE DCOHEN % Y
N VIEW DCOHEN % Y
N PROCEDURE CKARI % Y
N SEQUENCE CKARI % Y
N SYNONYM CKARI % Y
N PROFILE CKARI % Y
N ROLE CKARI % Y
N ROLLBACK STATEMENT CKARI % Y
N TABLE CKARI % Y
N VIEW CKARI % Y
N DML JOTTKE % Y
N TRIGGER CKARI % Y
N TYPE CKARI % Y
N PROCEDURE JOTTKE % Y
N DML GROEHM % Y
N INDEX GROEHM % Y
N PROCEDURE GROEHM % Y
N PROFILE GROEHM % Y
N ROLE GROEHM % Y
N ROLLBACK STATEMENT GROEHM % Y
N SEQUENCE GROEHM % Y
N SYNONYM GROEHM % Y
N TABLE GROEHM % Y
N TRIGGER GROEHM % Y
N TYPE GROEHM % Y
N VIEW GROEHM % Y
N DML ALUM % Y
N INDEX ALUM % Y
N PROCEDURE ALUM % Y
N PROFILE ALUM % Y
N ROLE ALUM % Y
N ROLLBACK STATEMENT ALUM % Y
N SEQUENCE ALUM % Y
N SYNONYM ALUM % Y
N TABLE ALUM % Y
N TRIGGER ALUM % Y
N TYPE ALUM % Y
N VIEW ALUM % Y
N DML PDAVIS % Y
N INDEX PDAVIS % Y
N PROCEDURE PDAVIS % Y
N PROFILE PDAVIS % Y
N ROLE PDAVIS % Y
N ROLLBACK STATEMENT PDAVIS % Y
N SEQUENCE PDAVIS % Y
N SYNONYM PDAVIS % Y
N TABLE PDAVIS % Y
N TRIGGER PDAVIS % Y
N TYPE PDAVIS % Y
N VIEW PDAVIS % Y
N DML NUMA % Y
N INDEX NUMA % Y
N INDEX JOTTKE % Y
N SEQUENCE JOTTKE % Y
N SYNONYM JOTTKE % Y
N TABLE JOTTKE % Y
N VIEW JOTTKE % Y
N DML GKING % Y
N INDEX GKING % Y
N PROCEDURE GKING % Y
N SEQUENCE GKING % Y
N SYNONYM GKING % Y
N TABLE GKING % Y
N VIEW GKING % Y
N DML STUCKER % Y
N INDEX STUCKER % Y
N PROCEDURE STUCKER % Y
N SEQUENCE STUCKER % Y
N SYNONYM STUCKER % Y
N TABLE STUCKER % Y
N VIEW STUCKER % Y
N INTERNAL SCHEMA SYSTEM % Y
N INTERNAL SCHEMA SYS % Y
N INTERNAL SCHEMA ORACLE_OCM % Y
N INTERNAL SCHEMA XDB % Y
N INTERNAL SCHEMA SYSMAN % Y
N INTERNAL SCHEMA WMSYS % Y
N INTERNAL SCHEMA DBSNMP % Y
N INTERNAL SCHEMA MGMT_VIEW % Y
N INTERNAL SCHEMA DIP % Y
N INTERNAL SCHEMA OUTLN % Y
N INTERNAL SCHEMA EXFSYS % Y
N INTERNAL SCHEMA ANONYMOUS % Y