Versions Compared

Version Old Version 28 New Version 29
Changes made by

Jim Hardtke

Jim Hardtke

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Input Name

Input Code

Required

Description

Column Drop ActionFDORA_COL_DROP_ACTIONNo

Determines what action to take for "dropping" columns.

Can be set to SET UNUSED or DROP.

Defaults to SET UNUSED.

Revert to Baseline IDFDORA_REVERT_TO_BASELINE_IDNo

Numeric ID of the baseline to revert an environment to.

Leave blank to create a new baseline.

Table RenamesFDORA_TABLE_RENAMESNo

Table rename string. The format is NEW_OWNER.NEW_TABLE_NAME=OLD_OWNER.OLD_TABLE_NAME

Info

Multiple table renames can be listed by comma separating them on the input.


Index RenamesFDORA_INDEX_RENAMESNo

Index rename string. The format is NEW_OWNER.NEW_INDEX_NAME=OLD_OWNER.OLD_INDEX_NAME

Info

Multiple index renames can be listed by comma separating them on the input.


Column RenamesFDORA_COLUMN_RENAMESNo

Column rename string. The format is NEW_OWNER.NEW_TABLE_NAME.NEW_COLUMN_NAME=OLD_OWNER.OLD_TABLE_NAME.OLD_COLUMN_NAME

Info

Multiple column renames can be listed by comma separating them on the input.


Trigger RenamesFDORA_TRIGGER_RENAMESNo

Trigger rename string. The format is NEW_OWNER.NEW_TRIGGER_NAME=OLD_OWNER.OLD_TRIGGER_NAME

Info

Multiple trigger renames can be listed by comma separating them on the input.


Constraint RenamesFDORA_CONSTRAINT_RENAMESNo

Constraint rename string. The format is NEW_OWNER.NEW_TABLE_NAME.NEW_CONSTRAINT_NAME=OLD_OWNER.OLD_TABLE_NAME.OLD_CONSTRAINT_NAME

Info

Multiple constraint renames can be listed by comma separating them on the input.


Synonym RenamesFDORA_SYNONYM_RENAMESNo

Synonym rename string. The format is NEW_OWNER.NEW_SYNONYM_NAME=OLD_OWNER.OLD_SYNONYM_NAME

Info

Multiple synonym renames can be listed by comma separating them on the input.


Sequence RenamesFDORA_SEQUENCE_RENAMESNo

Sequence rename string. The format is NEW_OWNER.NEW_SEQUENCE_NAME=OLD_OWNER.OLD_SEQUENCE_NAME

Info

Multiple sequence renames can be listed by comma separating them on the input.


View RenamesFDORA_VIEW_RENAMESNo

View rename string. The format is NEW_OWNER.NEW_VIEW_NAME=OLD_OWNER.OLD_VIEW_NAME

Info

Multiple view renames can be listed by comma separating them on the input.


Include TablespacesFDORA_TABLESPACE_FLGNoSetting this to true causes create statements to include tablespace information where appropriate.  This adds the tablespace clause to all creates. Defaults to false.  Requires segments attributes to be enabled also.
Include Segment attributesFDORA_SEGMENT_ATTRIBUTES_FLGNoSetting this to true causes create statements to include tablespace segment attribute information where appropriate.  Defaults to false.
Include StorageFDORA_STORAGE_FLGNoSetting this to true causes create statements to include storage information where appropriate.  This adds the STOREAGE clause with its values on all creates. Defaults to false.    Requires segments attributes to be enabled also. 

  

Outputs

Output Name

Required

Description

FDORA_OUT_BASELINE_ID

No

Outputs the BaseLine ID which was built.

FDORA_OUT_BL_TABLE_COUNTNoCount of tables stored in the baseline.
FDORA_OUT_BL_INDEX_COUNTNoCount of indexes stored in the baseline.
FDORA_OUT_BL_CONSTRAINT_COUNTNoCount of constraints stored in the baseline.
FDORA_OUT_BL_SEQUENCE_COUNTNoCount of sequences stored in the baseline.
FDORA_OUT_BL_PROCEDURES_COUNTNoCount of procedures stored in the baseline.
FDORA_OUT_BL_VIEWS_COUNTNoCount of views stored in the baseline.
FDORA_OUT_BL_SYNONYMS_COUNTNoCount of synonyms stored in the baseline.
FDORA_OUT_BL_MVIEW_COUNTNoCount of materialized views stored in the baseline.
FDORA_OUT_BL_MVIEW_LOG_COUNTNoCount of materialized view logs stored in the baseline.
FDORA_OUT_BL_PRIVILEGES_COUNTNoCount of privileges stored in the baseline.

...