This document provides ‘quick-start’ instructions for installing and configuring Oracle REST Data Services (ORDS) to enable the Oracle Database API for MongoDB on an Oracle Database running on Oracle Exadata Cloud Service (ExaCS) or any supported Oracle environment. Please be aware this document is intended to…
When planning a database migration, understanding what needs to move is only half the battle. The real challenge often lies in understanding how much effort it will take to remediate incompatible queries, data structures, or application logic. For teams tackling…
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 opinions and technical assumptions often cloud decision-making, leaving businesses uncertain…
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 (maybe you see where this is going…). In order to…
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 DADisableEjectNotification -bool YES;sudo pkill diskarbitrationd
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 )” Install Steps Single Command brew install docker; brew install docker-compose; brew…
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!
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…
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 I’ve adjusted the script to now respect the startup status setting in oratab!!! Enjoy!…