If you've kept abreast of what's new in the latest release of the database, you will probably be aware of three major enhancements to partitioning in Oracle 11g. Firstly, there's the new reference (ref) partitioning where you can partition one table based on a key value in another, so that for example you can partition the order details table based on the same key as the orders table. The second e
![Investigating Oracle 11g Interval Partitioning](https://cdn-ak-scissors.b.st-hatena.com/image/square/89e665e9ffedb11fac4fd14598dcd8015b5b0749/height=288;version=1;width=512/https%3A%2F%2Fwww.rittmanmead.com%2Fblog%2Fcontent%2Fimages%2F2021%2F10%2Ftech-bg%408x.png)