I have built SSIS packages to load data from one Oracle database to another before, but never had I come across this error until recently: “ROW-00060: Internal error: [dainsert,16] Source: Oracle Destination: Oracle Error Occurred @ after 403k records.” Initially, I thought that some constraint had been violated on the destination data source – like … Read more
There is a great article called “EF Database First with ASP.NET MVC” by Tom FitzMacken that is part of Microsoft’s ASP.NET MVC tutorial. I wanted to create a website using the steps outlined here, except instead of using a SQL Server database (as was presented in the article), I wanted to use an Oracle 12c … Read more
UPDATE: I was informed by an Oracle Database expert that starting with Oracle 12c, you can indeed have an identity column, and no trigger or sequence is required. The below post still applies to Oracle 11g and older. If most of your database experience is with SQL Server (as mine is), you’re probably used to … Read more