ora2pgpro

Table of Contents

1. Description

2. Features

3. Installation and Setup

Install Oracle Instant Client

Connect Distribution

Install Package

Supported Distributions

4. Configuration

Usage

Oracle Database Connection

Data Encryption with Oracle Server

Testing Connection

Troubleshooting

Oracle Schema to Export

Export Type

Limiting Objects to Export

Control of Full Text Search Export

Modifying Object Structure

Oracle Spatial to PostGIS

Postgres Pro Import

Column Type Control

Taking Export Under Control

Special Options to Handle Character Encoding

PL/SQL-to-PL/pgSQL Conversion

Other Configuration Directives

5. Usage Examples

Materialized Views

Exporting Views as Postgres Pro Tables

Migration Cost Assessment

Global Oracle Migration Assessment

Migration Assessment Method

Improving Indexes and Constraints Creation Speed

Exporting LONG RAW

Global Variables

Migration Test

Data Validation

Use of System Change Number (SCN)

Change Data Capture (CDC)

Importing BLOB as Large Objects

Exporting Packages

Exporting Associative Arrays

A. Release Notes

ora2pgpro 24.1.1

ora2pgpro 23.2.1