Oracle SQL Configuration

• exceptionHandler

Whether to comment out exception blocks in PL/SQL.

true: Comment out the exception blocks.

false: Retain the exception blocks as they are.

• true
• false

false

exceptionHandler=TRUE

• TxHandler

Whether to comment out COMMIT and ROLLBACK operations in PL/SQL.

true: Comment out the operations.

false: Retain the operations as they are.

• True
• False

True

TxHandler=True

• foreignKeyHandler

Whether to comment out foreign key constraints.

true: Comment out the constraints.

false: Retain the constraints as they are.

• true
• false

true

foreignKeyHandler=true

• globalTempTable

Valid values are GLOBAL and LOCAL. Currently, the target database does not support GLOBAL.

• GLOBAL
• LOCAL

LOCAL

encodingFormat=LOCAL

• onCommitDeleteRows

Valid values are DELETE and PRESERVE. Current Version V100R008

• DELETE
• PRESERVE

DELETE

onCommitDeleteRows=DELETE

• maxValInSequence

Maximum sequence value supported by the database. Currently, the maximum value supported by the database is 9223372036854775807.

1-9223372036854775807

9223372036854775807

maxValInSequence=9223372036854775807

• mergeImplementation

Method for migrating a merge statement.

SPLIT: The merge statement is split into individual queries during migration for query optimization.

WITH: The merge statement is migrated using a WITH clause.

• WITH
• SPLIT
• None

WITH

mergeImplementation=None

• RemoveHashPartition

Whether to comment out HASH PARTITION statements.

true: Comment out the constraints.

false: Retain the HASH PARTITION statements as they are.

• true
• false

true

RemoveHashPartition=false

• RemoveHashSubPartition

Whether to comment out HASH SUBPARTITION statements.

true: Comment out the constraints.

false: Retain HASH SUBPARTITION statements as they are.

• true
• false

true

RemoveHashSubPartition=false

• RemoveListPartition

Whether to comment out LIST PARTITION statements.

true: Comment out the constraints.

false: Retain LIST PARTITION statements as they are.

• true
• false

true

RemoveListPartition=false

• RemoveListSubPartition

Whether to comment out LIST SUBPARTITION statements.

true: Comment out the constraints.

false: Retain the LIST SUBPARTITION statements as they are.

• true
• false

true

RemoveListSubPartition=false

• RemoveRangeSubPartition

Whether to comment out RANGESUBPARTITION statements.

true: Comment out the constraints.

false: Retain the RANGESUBPARTITION statements as they are.

• true
• false

true

RemoveRangeSubPartition=false

• MigSupportSequence

Whether to enable the migration of SEQUENCE statements.

true: enables the conversion of CREATE to INSERT.

false: disables the migration of CREATE.

• true
• false

true

MigSupportSequence=false

• RemovePartitionTS

Whether to comment out PartitionTS statements.

true: Comment out the PartitionTS statements.

false: Retain the PartitionTS statements as they are.

• true
• false

true

RemovePartitionTS=true

• BitmapIndexSupport

Whether to comment out for BitmapIndex

COMMENT will comment the entire input script BTREE will retain as they are

• comment
• btree

comment

BitmapIndexSupport=comment

• pkgSchemaNaming

The following options are supported:

TRUE - schema1.package1#procedure1 should be changed to package1.procedure1

FALSE - schema1.package1#procedure1 will not be removed

• true
• false

true

pkgSchemaNaming=true

• plsqlCollection

The following options are supported:

• varray
• localtable
• none

• varray
• localtable
• none

varray

plsqlCollection=varray

• commentstorageparameter

Whether to comment out the storage parameters in a table or index.

true: Comment out the storage parameters.

false: Retain the storage parameters as they are.

• true
• false

true

commentStorageParameter=true

• MigSupportForListAgg

Whether to enable the migration of ListAgg statements.

true: enables the migration of ListAgg.

false: disables the migration of ListAgg.

• true
• false

true

MigSupportForListAgg=false

• MigSupportForRegexReplace

Whether to enable the migration of RegexReplacestatements.

true: enables the migration of RegexReplace.

false: disables the migration of RegexReplace.

• true
• false

true

MigSupportForRegexReplace=false

• commentPragmaAutomationTrans

Whether to comment out the AutomationTrans parameters in a table or index.

true: Comment out the AutomationTrans. false: Retain the AutomationTrans parameters as they are.

• true
• false

true

commentPragmaAutomationTrans=true

• supportJoinOperator

Indicates whether the left/right outer join operator (+) is supported.

The following options are supported:

• true
• false

• true
• false

false

supportJoinOperator=false

• migInsertWithTableAlias

The following options are supported:

• true
• false

• true
• false

true

migInsertWithTableAlias=true

• varraySize

Varray datatype size

• NA

1024

varraySize=1024

• varrayObjectSize

VarrayObject datatype size

• NA

10240

varrayObjectSize= 10240

• migrationScope

Whether to package split or migrate completely.

• pkgSplit
• completeMigration

completeMigration

migrationScope=completeMigration

• migSupportConnectBy

The following options are supported:

• true
• false

true: enables the migration of connectBy.

• true
• false

true

migSupportConnectBy = true

• migrate_ConnectBy_Unnest

Whether to migrate connectBy and Unrest.

true: enables the migration of connectBy and Unnest.

false: retains the original value.

• true
• false

true

migrate_ConnectBy_Unnest=true

• extendedGroupByClause

Whether to migrate the following extended functions of GROUP BY:

• grouping sets
• cube
• rollup

• true
• false

false

extendedGroupByClause=false

• supportDupValOnIndex

Whether to migrate DUP_VAL_ON_INDEX.

• UNIQUE_VIOLATION(V1R8)
• OTHERS(older versions)

UNIQUE_VIOLATION

supportDupValOnIndex=UNIQUE_VIOLATION

• pkgvariable

Whether to migrate pkgvariable.

• localtable
• sys_set_context
• none

localtable

pkgvariable = localtable

• addPackageNameList

The following options are supported:

• true
• false

Set package_name_list to <schema_name> and invoke this schema.

• true
• false

false

addPackageNameList = false

• addPackageTag

The following options are supported:

• true
• false

If this parameter is set to true, PACKAGE is added in front of AS|IS in the stored procedure/function declaration.

• true
• false

false

addPackageTag = true

• addGrantLine

The following options are supported:

• true
• false

true: adds GRANT rows to each stored procedure/function at the end of the file.

• true
• false

false

addGrantLine = true

• MigDbmsLob

The following options are supported:

• true
• false

• TRUE - DBMS_LOB is migrated.

• FALSE - DBMS_LOB is not migrated

• true
• false

false

MigDbmsLob=false

• uniqueConsForPartitonedTable

Unique or primary key constraint for partitioned table.

• comment_partition
• comment_unique
• none

comment_partition

uniqueConsForPartitonedTable = comment_partition

• MigSupportForRegexFunc

Possible values for MigSupportForRegexReplace.

• true
• false

false

MigSupportForRegexFunc=false

• migSupportUnnest

Possible values for migSupportUnnest.

• true
• false

true

migSupportUnnest = true

• MDSYS.MBRCOORDLIST

Replace the unsupported datatype MDSYS.MBRCOORDLIST with a user-defined datatype.

• None
• Can enter any free text

None

MDSYS.MBRCOORDLIST=None

• MDSYS.SDO_GEOMETRY

Replace the unsupported datatype MDSYS.SDO_GEOMETRY with a user-defined datatype.

• None
• Can enter any free text

None

MDSYS.SDO_GEOMETRY=None

• GEOMETRY

Replace the unsupported datatype GEOMETRY with a user-defined datatype.

• None
• Can enter any free text

None

Input should not migrate.

GEOMETRY=None

• tdMigrateAddMonth

Possible values for addMonth.

• true
• false

None

tdMigrateAddMonth=false

IF TRUE THEN mig_ORA_ext.ADD_MONTHS (APPENDING mig_ORA_ext) OTHERWISE NOT APPEND.

tdMigrateAddMonth=false