Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux.┬áThis is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

Advertisements

Eating An Elephant – How To Work With Huge Datasets In Oracle And SQL Server

Simplifying complex problems is difficult but when done, the rewards are definitely worth it. How I single-handedly managed to migrate 55 Billion rows in 4000+ tables: Last year, I created PowerPump a PowerShell based data copy server which continuously migrated 4000+ Oracle tables to SQL Server. It was no simple task given that I had … Continue reading Eating An Elephant – How To Work With Huge Datasets In Oracle And SQL Server

Oracle – Find A Needle In The Hay Stack – How To Pinpoint Data Errors Like “ORA-12899: value too large for column”

Nasty data-related errors: If you are looking to resolve one of these types of errors, you are in the right place. Please keep reading. ORA-01400: cannot insert NULL into (string) ORA-01401: inserted value too large for column ORA-02290: check constraint (string.string) violated ORA-02291: integrity constraint (string.string) violated - parent key not found ORA-02292: integrity constraint … Continue reading Oracle – Find A Needle In The Hay Stack – How To Pinpoint Data Errors Like “ORA-12899: value too large for column”

How to Resolve – “ORA-24381: error(s) in array DML”

"Oops! Something went wrong" seems to be the fashionable thing to do when throwing errors these days. Not surprisingly, when issuing a query from PowerShell against Oracle, it kept producing this error at random ORA-24381: error(s) in array DML The error did not always happen. It only happened once in a while and it was … Continue reading How to Resolve – “ORA-24381: error(s) in array DML”