OraMatt: YABAOracle

Yet Another Blog About Oracle

Category: database

  • A Quick Guide to Exporting Data from Oracle Database

    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…

  • Using DBMS_REDEFINITION

    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…

  • Migrate to Automatic Storage Management (ASM)

    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: http://docs.oracle.com/database/121/OSTMG/asm_rman.htm#OSTMG12000 You can download the…

  • Loading LOBs into a Table

    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…

  • Quick Remote Diagnostics…

  • Edition Based Redefinition Demo

    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…

  • Quick TDE demo

     

  • Quick Lockdown Script

    Just a little script to lockdown default Oracle accounts and randomly change passwords

  • SGA Fiddling…

    Just a little script to mess with the SGA

  • DataPump — Export & Import Scripts

    Use these 2 scripts together and you should be good to go… Here’s the DataPump Export Script Here’s the DataPump Import Script

Navigation

About

I’m Matt and I do Oracle things.