ora2pgpro 26.1.1 Documentation

Table of Contents

1. Description

2. Features

3. Installation and Setup

3.1. Install Oracle Instant Client

3.2. Connect Distribution

3.3. Install Package

3.4. Supported Distributions

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

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

6. Reference

ora2pgpro — migrate an Oracle database to Postgres Pro

A. Release Notes

A.1. ora2pgpro 26.1.1

A.2. ora2pgpro 24.2.1

A.3. ora2pgpro 24.1.1

A.4. ora2pgpro 23.2.1