Monthly Archive:: May 2016

Datapump import failed with ORA-04091: table is mutating

Recently one of my application team asked me to refresh few tables in a lower environment database using the production copy of the tables. As usual, I opted to perform a Datapump import (impdp) to refresh (data

Oracle 12c: TRUNCATE can be cascaded down to the lowest level of hierarchy

Do you recall the following error? ---// ---// ORA-02266 when truncating table //--- ---// SQL> truncate table parent; truncate table parent * ERROR at line 1: ORA-02266: unique/primary keys in table referenced by enabled foreign keys Well,

Oracle 12c: DDL Logging.. will it serve the purpose?

Oracle had introduced a cool feature in version 11g, where we were able to log or track DDL statements executed in the database by means of a parameter called ENABLE_DDL_LOGGING without setting up database auditing. Setting ENABLE_DDL_LOGGING

Oracle 12c: Global Index maintenance is now asynchronous

Introduction Maintaining global indexes were always a expensive task in Oracle, particularly in the context of partitioned tables, where dropping or truncating a table partition could cause a global index to become UNUSABLE/INVALID unless specified to update
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed