ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the one in the control file. Sometimes it so happened that after duplicating the database name in SPFILE with which you started the instance with is not matching the one in the control file. Explanation: ===================== … Continue reading ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

Delete Duplicate Rows Oracle

Check for Duplicate Row using Group By function This script deletes each row in the group after the first row. DELETE FROM our_table WHERE rowid not in (SELECT MIN(rowid) FROM our_table GROUP BY column1, column2, column3... ; delete FROM TXN_TABLE WHERE rowid not in (SELECT MIN(rowid) FROM TXN_TABLE GROUP BY TRNX_UID); select COUNT(*) FROM TXN_TABLE … Continue reading Delete Duplicate Rows Oracle