PolarDB for PostgreSQL (Compatible with Oracle) is fully compatible with Oracle syntax, supports Oracle drivers, and uses the same file organization structure as Oracle, which minimizes code changes when migrating from an existing Oracle database. The cluster uses a shared-everything architecture and supports multiversion concurrency control (MVCC) and the native Oracle Call Interface (OCI). This way, you can migrate data from an Oracle database to a PolarDB for PostgreSQL (Compatible with Oracle) cluster in a few clicks.
Partitioning
PolarDB for PostgreSQL (Compatible with Oracle) supports the following partition types and operations:
Range partitioning
Interval partitioning
Partition splitting
Partition merging
Partition templates
Global indexes on partitioned tables are also supported, keeping queries efficient as data grows across partitions.
Stored procedures
PolarDB for PostgreSQL (Compatible with Oracle) is highly compatible with Oracle stored procedures. The following common statements are supported:
COLLECTION
GOTO
SAVEPOINT
ROLLBACK TO
CURSOR
EXECUTE IMMEDIATE
RETURN
DBLINK
A database link lets you run SQL queries against external data sources using the same syntax as local queries. Three connection methods are available:
Foreign data wrapper
Database link
dblink function
Supported cross-database connections:
| Target database | Supported |
|---|---|
| PolarDB for PostgreSQL (Compatible with Oracle) | Yes |
| Oracle | Yes |
| PostgreSQL | Yes |
| MySQL | Yes |
For complex queries that span databases, PolarDB for PostgreSQL (Compatible with Oracle) applies the following optimizations to push computation closer to the source:
Predicate pushdown
Join pushdown
ORDER BY optimization
SORT BY optimization
Compatibility with advanced features
PolarDB for PostgreSQL (Compatible with Oracle) supports the following Oracle drivers:
OCI driver
Pro*C driver
The following Oracle advanced features are also supported:
Hints
SQL plan management (SPM)
CREATE TYPE statement
Materialized views
Profiles
The cluster is fully compatible with the PostgreSQL syntax and PostgreSQL tooling.