Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Cloud Solutions
  • Postgres Extensions
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Training Courses
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info

Facebook
Postgres Pro
  • Services
    24×7×365 Technical Support Migration to PostgreSQL High Availability Deployment Database Audit Remote DBA for PostgreSQL
  • Products
    Postgres Pro Enterprise Postgres Pro Standard Cloud Solutions Postgres Extensions
  • Resources
    Blog Documentation Webinars Videos Presentations
  • Community
    Events Training Courses Books Demo Database Mailing List Archives
  • About
    Leadership team Partners Customers In the News Press Releases Press Info
Facebook
Downloads
ora2pgpro
   Next

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.2.1
ora2pgpro 24.1.1
ora2pgpro 23.2.1

   Next
   Chapter 1. Description
pdf

This page in other versions:

ora2pgpro 23
ora2pgpro 24
Есть вопросы? Напишите нам!

Соглашаюсь с условиями обработки персональных данных



✖
×
ora2pgpro 23 ora2pgpro 24
Go to ora2pgpro 24
Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Cloud Solutions
  • Postgres Extensions
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Training Courses
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Cloud Solutions
  • Postgres Extensions
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Services
  • 24×7×365 Technical Support
  • Migration to Postgres
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Community
  • Events
  • Training Courses
  • Intro Book
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info
Contacts
  • Neptune House, Marina Bay, office 207, Gibraltar, GX11 1AA
  • [email protected]
  • Facebook
Get in touch!



© Postgres Professional Europe Limited, 2015 — 2025
EULA EULA for Cloud Environments Privacy Policy GDPR Compliance Commitment
© Postgres Professional Europe Limited, 2015 — 2025
EULA
EULA for Cloud Environments
Privacy Policy
GDPR Compliance Commitment
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.