Oracle Configuration

Oracle parameters are used to customize rules for Oracle script migration.

Open the antlr-features-oracle.properties file in the config folder and set the parameters in Table 1 as required.

**Table 1** Parameters in the antlr-features-oracle.properties file
Parameter	Description	Value Range	Default Value	Example
table.index.rename	Whether to rename an index as table name_index name during its operation.	true false	false	table.index.rename=false
table.constraint.rename	Whether to rename a constraint as table name_constraint name during its operation.	true false	false	table.constraint.rename=false
table.foreign.key.comment	Whether to comment out foreign key constraints.	true false	true	table.foreign.key.comment=true
table.storage.para.comment	Whether to comment out storage parameters.	true false	true	table.storage.para.comment=true
table.plsql.exception	Whether to comment out exception modules in PL/SQL. true (default value): The exception modules are commented out.	true false	true	table.plsql.exception=true;
table.create.inSensitive	Whether to convert column fields to lowercase. true (default value): The column fields are converted to lowercase. false: The uppercase and lowercase letters are the same as those in the original SQL statement.	true false	true	table.create.inSensitive=true
table.plsql.pkgConvert	Whether to replace the package. The default value is false, indicating common conversion. The value true indicates package variables are replaced.	true false	false	table.plsql.pkgConvert=false