-
Title
Messages about event log about failed grants on temporary tables on target when 9i DDL is enabled -
Description
The following messages keep appearing in target event log (when 9i DDL replication is enabled on source) though replication is working fine:
opo_ddl 2010-04-18 21:22:10.439725 8327216 1029 s:1 9i DDL, User Name = "NAME" Default Schema = "SYS"
opo_ddl 2010-04-18 21:22:10.450904 8327216 1029 s:1 DDL_SQL = "grant select,insert on sys.ora_temp_1_ds_84904 to "USERNAME""
opo_ddl 2010-04-18 21:22:10.486853 8327216 1029 s:1 FAILED Applying DDL - Oracle time: 04/18/10 21:22:05 Poster time: 04/18/10 21:22:10
 -
Cause
The temporary tables do not exist on target.
-
Resolution
These are some of the side effects seen when enabling 9i DDL replication. Since the temporary table does not exist on target, the replicated DDL for GRANT on such tables keep failing. It does not cause any stoppage of replication and the only downside is the additional logging in target event log.
Â