⚠️ Review in Progress This YugabyteDB Tip is currently under review for technical correctness by YugabyteDB engineering. This notice will be removed […]
Read More
Oracle-Style Partition Views in YugabyteDB: USER_TAB_PARTITIONS and ALL_TAB_PARTITIONS
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 MoreMigrating 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 More