Exporting data from Oracle databases is a common task that every DBA and developer faces. Whether you’re migrating data, creating backups, or generating reports, having the right export strategy can save you time and headaches. In this post, I’ll walk…
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…
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…
Just a little script to lockdown default Oracle accounts and randomly change passwords
Just a little script to mess with the SGA
Use these 2 scripts together and you should be good to go… Here’s the DataPump Export Script Here’s the DataPump Import Script