select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Replication and streams

ora_migrator

Tools to migrate Oracle databases to PostgreSQL

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packageora_migrator
Version1.1.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars121
Latest commit2024-05-23
Latest release2023-08-01
Catalogue updated2026-08-30

Related extensions

Requires

db_migratorTools to migrate other databases to PostgreSQL
oracle_fdwforeign data wrapper for Oracle access

See also

orafceFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pg_dbms_jobExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
check_orapgValidate Oracle-to-PostgreSQL or EDB migrations by comparing database objects, privileges, attributes, comments, and row counts.
pg_dbms_metadataExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
db_migratorTools to migrate other databases to PostgreSQL
pg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2
plpgsql_wrapOracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
dbms_sqlImplements a subset of Oracle's DBMS_SQL package API to ease application migration to PostgreSQL.
pg_dbms_lockExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_errlogEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.