Oracle ODP.NET: Resolve “Arithmetic operation resulted in an overflow” or “Specified cast is not valid”

This is similar to "Oracle Nasty Dates Finder for .NET folks!" but this time it is for numbers instead of dates! I ran into this issue as I was moving data from Oracle to SQL Server. So, you are working with Oracle using ODP.NET and you have a simple, straight-forward SELECT * FROM TABLE; Alternatively, …

Advertisement

Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

This is one of those obscure errors that has no answer on the Web. I ran into this error trying to migrate an Oracle table to SQL Server (one of many). The issue seemed to be only with certain rows of this table as it migrated majority of the data without issues. Below is the …

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 …

Oracle – Calculating Business Days Between Two Dates (With Holiday Exclusion)

If you search the web on how to calculate the number of business days between two dates in Oracle, you would see so many results. Here is one more with some explanation to go with it. There is no magic to it. It is simple and straight-forward and this is as basic as it can …

Oracle – Recycle Bin Basics

Basics of Oracle recycle bin - A simple post to illustrate the power of recycle bin and how to retrieve objects back from it.