ORA-14137 after executing drop table purge;
I had a case where the drop table with purge option DDL statement produce the error from the title and left partitioned table in the partially dropped state. I can still see the table and all belonging objects like indexes/constraints… in dictionary, but If I try to select from that table, I get the following […]
Tips when performing Oracle Retail upgrade (as well as all kind of upgrades based on Oracle technology)
Having a good backup strategy before performing all kind of upgrades are essential when things are going wrong and you have to revert to a previous stage. This is not only important when upgrading infrastructure software like Oracle Database, but for all upgrades, especially with application software upgrades. I’ve been involved in several Oracle Retail […]
Moving Oracle running process to background without interruption on AIX
Imagine that you are going home, but before you go, you start some script (bash, Oracle SQL*Plus, or PL/SQL procedure) for which you didn’t know or didn’t think in advance that job you start to execute can take a long time to finish, and can’t be interrupted. In this blog I’m assuming you are running […]