we had been using replication in 8.0.5 database. We migrated to 11.2.0.4 and stopped the replication. We are using Oracle forms 6i.
Recently we have been facing some issues when inserting data into database. Data insertion is not complete. Some columns are inserted and others are null. We have been getting ORA-00604 unique constraint error pointing to SYSTEM.SYS_C003693.
SYSTEM.SYS_C003693 is an unique index on SYSTEM.DEF$_AQCALL table in system tablespace.
Unable to understand why there is unique constraint error on this table which we are not using after replication.
Please suggest if we can drop this table/index.