I tested an application upgrade (QA) on one off our applications. When we ran the upgrade script, it stopped with the error ORA-02429: cannot drop index used for enforcement of unique/primary key.
We checked the index and it was an invisible index created during a tuning session some time ago.
We were a bit puzzled how this index suddenly can become the index to enforce primary key.
Month: August 2014
Bulk Collect using LIMIT and %notfound
I have used bulk collect for some time now and it is a great feature that helps
speeding up processing large amount of data. The LIMIT parameter is useful
since it reduces memory usage. I have just used the feature deleting 2290266
rows.
magnusjohanssondba 