Hi Masters,
I am getting the below error for doing purging. how to resolve this ? please advise ..
ORA-00001: unique constraint (SMP_RPTUSER_CO.U_GTT_ID_VARCHAR) violated
ORA-06512: at "SMP_RPTUSER_CO.PURGING", line 355
Line 355:
+++++++
execute immediate 'INSERT /*+ append */ INTO '||tempTableName||' (id, rid) SELECT c.id, c.ROWID FROM '||tableName||' '||lPartitionQuery||' c, '
||parentTableName||' p WHERE c.'||childRefColumnName||'=p.'||lIdColumnInParentTable||'';
rwCount := SQL%ROWCOUNT;
COMMIT;
sp_DropTable('PURGE_GTT_ID_VARCHAR');
execute immediate 'CREATE GLOBAL TEMPORARY TABLE PURGE_GTT_ID_VARCHAR ( id NVARCHAR2(256) NOT NULL, rid ROWID NOT NULL) ON COMMIT PRESERVE ROWS';
p_CreateIndex('U_GTT_ID_VARCHAR','PURGE_GTT_ID_VARCHAR','ID',NULL,TRUE);
Please advise ..
BR
Frd