The Oracle SH (Sales History) schema is the standard Oracle example of a star schema data warehouse.
It has a central SALES fact table, six dimension tables, two materialized views, range-partitioned fact tables, and bitmap indexes on low-cardinality columns.
All of those features exist in every real Oracle data warehouse.
And all of them require decisions that a straightforward ora2pg run won't make for you.
This post walks through the exact steps I used to migrate SH from Oracle 19c to PostgreSQL 18 using ora2pg.
The Oracle SH sample schema is available on GitHub.
Continue reading “Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)”