If you’re migrating from Oracle and miss USER_TAB_PARTITIONS and ALL_TAB_PARTITIONS, you can recreate them in YugabyteDB with two simple views over the […]
Read More
Migrating Oracle Range Partitions to YugabyteDB (YSQL)
When moving Oracle partitions that omit a lower or upper bound, translate them to Postgres/YSQL using MINVALUE and MAXVALUE. Also remember that […]
Read MoreForeign Key References on Partitioned Tables
YugabyteDB now supports foreign key references to partitioned tables…a PostgreSQL 12+ feature that brings referential integrity to partitioned parents. This is available starting […]
Read MoreMulti-Column LIST Partitioning
Multi-column partitioning can be a powerful tool for organizing data. In databases like Oracle, you can define a LIST partition on multiple […]
Read MoreColocation Gotcha: Creating Hash-Partitioned Tables with Range Partitions in YugabyteDB
🟢 Update (Nov 2025): The colocation issue described in this tip has been fixed in YugabyteDB 2025.1.1.2. You can now create hash-partitioned […]
Read More