Monthly Archives: January 2017

Null rows being displayed after partitioning a table with Data

Null rows being displayed after partitioning a table with Data Partitioning in a Data Warehouse kind of environment is very common. In the recent times, I’ve observed a behavior with the Partitioned tables in Oracle, which I wanted to share … Continue reading

Posted in Oracle Database | Leave a comment

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC1F2B19A8, ORA-01092: ORACLE instance terminated. Disconnection forced

I was performing a clone from a cold backup in a 12c (12.1.0.2) environment and was stuck with the errors (ORA-04024 and ORA-01092). The database restore was completed but while performing the ‘alter database open resetlogs’ it was giving the … Continue reading

Posted in Oracle Database Clone Issues | 2 Comments