Database design is hard…seriously… If you need to modify a table after you’ve rolled it into production DBMS_REDEFINITION can really save you! Here’s a little example that shows taking a non-partitioned table and adding interval partitioning to it. Enjoy!
This is one of those topics that EVERYONE has a different take on and here’s mine! Using the LS_TABLE external table that you can find here you’ll be able to loop through all the files in a directory and load them into…
Virtual Private Database or VPD is one of those cool Oracle Database features that scare some folks because they think it’s SUPER HARD to setup and use. This little bit of demo code hopefully will dispel that … ENJOY! Create…
I’m a big fan of Edition-Based Redefinition that was introduced in Oracle Database 11gR2. Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time. Here’s a little…
Quick example