Chapter 4. Configuration
Table of Contents
- 4.1. Usage
- 4.2. Oracle Database Connection
- 4.3. Data Encryption with Oracle Server
- 4.4. Testing Connection
- 4.5. Troubleshooting
- 4.6. Oracle Schema to Export
- 4.2. Oracle Database Connection
- 4.7. Oracle Spatial to PostGIS
- 4.8. Postgres Pro Import
- 4.9. Column Type Control
- 4.10. Taking Export Under Control
- 4.11. Special Options to Handle Character Encoding
- 4.12. PL/SQL-to-PL/pgSQL Conversion
- 4.13. Other Configuration Directives
- 4.8. Postgres Pro Import
ora2pgpro configuration can be as simple as choosing the Oracle database to export and choosing the export type.
The full control of the Oracle database migration is managed in a single configuration file named ora2pgpro.conf. The format of this file consists of a directive name in upper case followed by a tab character and a value. Comments are lines beginning with a #. There is no specific order to place the configuration directives, they are set at the time they are read in the configuration file.
For configuration directives that just take a single value, you can use them multiple times in the configuration file but only the last occurrence found in the file will be used. For configuration directives that allow a list of values, you can use it multiple times, the values will be appended to the list. If you use the IMPORT directive to load a custom configuration file, directives defined in this file will be stored from the place the IMPORT directive is found, so it is better to put it at the end of the configuration file.
Values set in the command line options override values from the configuration file.