ora2pgpro 26.1.1 Documentation
Table of Contents
- 1. Description
- 2. Features
- 3. Installation and Setup
- 2. Features
- 4. Configuration
- 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.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.2. Oracle Database Connection
- 4.1. Usage
- 5. Usage Examples
- 5.1. Materialized Views
- 5.2. Exporting Views as Postgres Pro Tables
- 5.3. Migration Cost Assessment
- 5.4. Global Oracle Migration Assessment
- 5.5. Migration Assessment Method
- 5.6. Improving Indexes and Constraints Creation Speed
- 5.7. Exporting LONG RAW
- 5.8. Global Variables
- 5.9. Migration Test
- 5.10. Data Validation
- 5.11. Use of System Change Number (SCN)
- 5.12. Change Data Capture (CDC)
- 5.13. Importing BLOB as Large Objects
- 5.14. Exporting Packages
- 5.15. Exporting Associative Arrays
- 5.2. Exporting Views as Postgres Pro Tables
- 5.1. Materialized Views
- 6. Reference
- ora2pgpro — migrate an Oracle database to Postgres Pro
- A. Release Notes