Oracle Configuration
Oracle parameters are used to configure rules for Oracle script migration as required.
Open the antlr-features-oracle.properties file in the config folder and set the parameters in Table 1 as required.
| Parameter | Description | Value Range | Default Value | Example |
|---|---|---|---|---|
| Whether to rename an index as table name_index name during its operation. |
|
| table.index.rename=false |
| Whether to rename a constraint as table name_constraint name during its operation. |
|
| table.constraint.rename=false |
| Whether to comment out foreign key constraints. |
|
| table.foreign.key.comment=true |
| Whether to comment out storage parameters. |
|
| table.storage.para.comment=true |
| Whether to comment out exception modules in PL/SQL. true (default value): The exception modules are commented out. |
|
| table.plsql.exception=true; |
| 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. |
|
| table.create.inSensitive=true |
| Whether to replace packages. The default value false indicates the common conversion. The value true indicates that package variables are replaced. |
|
| table.plsql.pkgConvert=false |
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot