DDL EXCLUDE ALL
DDL EXCLUDE ALL
is a special processing option that is
intended primarily for Extract. DDL EXCLUDE ALL
blocks the
replication of DDL operations, but ensures that Oracle GoldenGate continues to keep
the object metadata current. When Extract receives DDL directly from the logmining
server (triggerless DDL capture mode), current metadata is always maintained.
You can use DDL EXCLUDE ALL
when using a method other
than Oracle GoldenGate to apply DDL to the target and you want Oracle GoldenGate to
replicate data changes to the target objects. It provides the current metadata to
Oracle GoldenGate as objects change, thus preventing the need to stop and start the
Oracle GoldenGate processes. The following special conditions apply to DDL
EXCLUDE ALL
:
-
DDL EXCLUDE ALL
does not require the use of anINCLUDE
clause. -
When using
DDL EXCLUDE ALL
, you can set theWILDCARDRESOLVE
parameter toIMMEDIATE
to allow immediate DML resolution if required.
To prevent all DDL metadata and operations from being replicated, omit
the DDL
parameter entirely.