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 useCREATE
andALTER
. MultipleOPTYPE
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 theTABLE
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 instringspec
are present (or false ifexcludestring
is specified and thestringspec
is present). If multiplestring
entries are made, at least one entry in eachstringspec
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 thisddlops
specification). -
The semicolon is required to terminate the parameter entry.
For example:
ddl optype (create, drop), objname (eric.*); ddl exclude objname (eric.tab*); exttrail a; exttrail b; ddl optype (create), objname (joe.*), string (“abc”, “xyz”) local; ddl optype (alter), objtype (index);
In this preceding example, the
exttrail a
gets creates and drops for all objects that belong toeric
, except for objects that start withtab
,exttrail a
also gets all alter index statements, unless the index name begins withtab
(the rule is global even though it’s included inexttrail b
).exttrail b
gets the same objects asa
, and it also gets all creates for objects that belong tojoe
when the stringabc
orxyz
is present in the DDL text. Theddlops.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.