Sometimes, when your EXPDP takes so long (probably because you have huge partitioned tables), when you try to IMPDP somewhere later you may receive the error: ORA-39083: Object type INDEX failed to create with error: ORA-14024: number of partitions of LOCAL index must equal that of the underlying table This usually happens because the export of …
Category: Oracle Database General
Oracle Database General
Mar 02
IMPDP failing with ORA-31625 and ORA-01031: insufficient privileges with Database Vault
Those days, I was having a lot of errors during my Import Datapump session in a Oracle 11g with Database Vault environment. As the schema was protected, first I did the overall check up making sure the user I was using to import had the DBA permission and I also gave it full access to …
Feb 28
How to delete the incarnations of an Oracle Database
In this article, I will talk about database incarnation and how to clean the old and obsoletes ones. It's not intended to show you how to clean the incarnations on the recovery catalog, but from the database itself! Let's start. Sometimes, after performing several database recoveries or "open resetlogs", you can end up with so …
Nov 28
ORA-12853, ORA-04031 and ORA-06512: at "SYS.UTL_RECOMP", line 865
Those days I created a really small 11.2.0.4 database in a very powerful Sun Sparc 64 processors server. I've set up the database to use as memory_target the minimal possible: 524M. I planed to increase this size later after preparing the DB Server. When I started enabling the Database Vault, I received the following error …
Nov 13
Howto apply OJVM PSU, DB PSU and Generic JDBC Patch in 11.2.0.4
Starting at October 2014, all the DB PSU come along with the OJVM PSU option on the main download page (Doc ID 756671.1). Oracle recommends to install both, as well as the Generic JDBC Patch that is also available there. In this tutorial, I will show how to install the OJVM PSU, DB PSU and JDBC …