The Rule Information dialog box shows all object rules which have been applied to a specific object - including general ones which have been overridden by more specific rules. The panel at the top of the dialog box lists the object rules and the panel at the lower right shows a summary display of all object rules applicable to the DDL object type and their current state. The discussion of rules on the Object Rules tab help page contains more information about object rules.

What the columns in the Object Rules Panel mean

Order

This is the order the rules will be applied in. They are automatically sorted from most general to most specific. The order will change as new rules are added and old rules are deleted.

Rule Action

This is the action the rule performs (substitute, discard etc.).

Rule Acts On

This column lists the type of object the rule will act on. If this column indicates Any Object the rule will be applied to all applicable object types. For example: you do not need to worry about CREATE TABLE DDL being affected by an OR REPLACE insert rule simply because the object type is not specified. The DDL Wizard only applies rules to the DDL object types for which they are appropriate.

User

Rules can be specific to a designated schema or can be applied in general to all schemas.

Object Name

Object manipulation rules can be applied to specific objects by name, all objects (*) or to objects based on wild card string matches (XYZ*, *XYZ and *XYZ*).

Component

This column indicates the specific component (PCTFREE clause, START WITH clause etc) that will be affected by the rule.

Substitution String

This column shows the text that will be substituted for a component. This field is only valid if the Rule Action column is Substitute Component.

Status

This column can have one of two values Active or Superseded. A superseded rule has been overridden by a more specific rule and has no effect - such rules are shown for information purposes only.