Using DDL Statements and Options for Filtering

INCLUDE (default) means include all objects that fit the rest of the description. EXCLUDE means to omit items that fit the description. Exclude rules take precedence over include rules.
OPTYPE specifies the types of operations to be included or excluded. You can use CREATE and ALTER. Multiple OPTYPE can be specified using parentheses. For example, OPTYPE (CREATE, ALTER). The asterisk (*) wildcard can be specified to indicate all operation types, and this is the default.
OBJTYPE specifies the TABLE operations to include or exclude. The wildcard can be specified to indicate all object types, and this is the default.
OBJNAME specifies the actual object names to include or exclude. For example, eric.*. Wildcards are specified as in other cases where multiple tables are specified. The default is *.
STRING indicates that the rule is true if any of the strings in STRINGSPEC are present (or false if EXCLUDESTRING is specified and the STRINGSPEC is present). If multiple STRING entries are made, at least one entry in each STRINGSPEC must be present to make the rule evaluate true.
For example:
```
DDLOPS STRING (“a”, “b”), STRING (“c”) EVALUATES true IF STRING “a” OR “b” IS PRESENT, AND STRING “c” IS PRESENT
```
LOCAL is specified if you want the rule to apply only to the current Extract trail (the Extract trail to which the rule applies must precede this DDLOPS specification).
The semicolon is required to terminate the parameter entry.

In the following example, DDL is used to capture CREATE and ALTER for all objects in eric except for those starting with name tab.
```
DDL &
INCLUDE OPTYPE CREATE &
INCLUDE  OPTYPE ALTER &
INCLUDE OBJNAME (eric.*) &
EXCLUDE OBJNAME (eric.tab*);
```
In the following example, the DDL captures CREATE for all objects in joe, alter for all index type objects
```
DDL &
INCLUDE OPTYPE CREATE &
INCLUDE OBJNAME (joe.*) &
INCLUDE OPTYPE ALTER &
INCLUDE OBJTYPE (index);
```
In the following example, the DDL captures CREATE for all objects in joe.
```
DDL &
INCLUDE OPTYPE CREATE &
INCLUDE OBJNAME (joe.*)
```
Note:
There can be only one DDL filtering statement. If DDL filter is long, use ampersand (&) sign to continue it on another line.
The DDLOPS.C module stores all DDL operation parameters and executes related rules.

Additionally, you can use the DDLOPTIONS parameter to configure aspects of DDL processing other than filtering and string substitution. You can use multiple DDLOPTIONS statements and Oracle recommends using one. If you are using multiple DDLOPTIONS statements, then make each of them unique so that one does not override the other. Multiple DDLOPTIONS statements are executed in the order listed in the parameter file.

See DDL and DDLOPTIONS.