I recently needed to dynamically set an environmental variable from reading the Oracle Inventory XML file. Typically you can find your Oracle Inventory location by looking here on Linux or here on Solaris. You should see the inventory_loc…
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!
Here’s a quick and simple script to help migrate a database over to Automatic Storage Management (ASM). The script implements the Oracle Documentation found here: You can download the script from GitHub here:
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…
Ever since I upgraded Safari the other day I kept getting spinning a spinning beach ball and Safari would NEVER respond. I figured out the culprit was all the Safari Extensions I had installed. After a bit of Google-Fu I…
Howdy y’all! I decided to add some additional features to my Oracle Init script. In this version I added Database Backup and Archive Log delete with RMAN as well as show status. Oh…and I included start/stop for Oracle Rest Data…
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…
Howdy y’all! If you ever need to import a VirtualBox image from the command line using vboxmanage and the image has a EULA that must be agreed to here’s the command: You DON’T need the switch just the . I…