OraMatt: YABAOracle

Yet Another Blog About Oracle

Category: oracle

  • Migration Viability Score – A Smarter Approach to Database Modernization

    As organizations evaluate the benefits of moving legacy or non-standard databases to enterprise-grade platforms, one recurring challenge persists: how to quantify whether a migration is truly worth the effort. Subjective…

  • Run Oracle 23ai on MacBook Pro with Apple Silicon (this works)

    I’ve been a long time fan of running containers to quickly spin up a developer environment unfortunately my preferred dev platform is MacOS on the new Apple Silicon based MacBooks…

  • Turn of Disk Eject Notifications on MacOS

    If you don’t care about being notified each and EVERY time a disk is ejected from MacOS, run the following command. sudo defaults write /Library/Preferences/SystemConfiguration/com.apple.DiskArbitration.diskarbitrationd.plist DADisableEjectNotification -bool YES;sudo pkill diskarbitrationd

  • Running Docker on a M2 MacBook

    I’ve had relative success running Docker x86-64 containers on my M2 MacBook with the following procedure: Run docker on Apple Silcon with hacks Prerequisite /bin/bash -c “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)” Install…

  • Parsing the Oracle Inventory XML file

    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 /etc/oraInst.loc on Linux…

  • 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…

  • 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…

  • Improved Oracle INIT script

    So….I was reviewing my INIT script that I posted here and I noticed there was no respect if a SID was marked as NO in /etc/oratab. I’ve adjusted the script…

  • 12c Data Redaction (DBMS_REDACT ) Demo

    Oracle 12c introduced A TON of new features and options. One of the COOLEST (IMHO) is the Data Redaction packages. For those not in the know here’s what the Data…

  • Create Random Data & Bulk Insert from Nested Table

    Sometimes I need to create random datasets to explore how queries will run, so I whipped up this little sample procedure as a way to do it. This is basically…

Navigation

About

I’m Matt and I do Oracle things.