|
請問是如何解決的.我這裡執行Replicate Seed Data出現錯誤.
declare
*
ERROR at line 1:
ORA-20000: ORA-00001: unique constraint (AR.AR_MEMO_LINES_ALL_TL_U2)
violated:ad_morg.replicate_table_data(AR_MEMO_LINES_ALL_TL,187):INSERT INTO AR_MEMO_LINES_ALL_TL (MEMO_LINE_ID, NAME, DESCRIPTION,
LANGUAGE, SOURCE_LANG, LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORG_ID) SELECT
MEMO_LINE_ID, NAME, DESCRIPTION, LANGUAGE, SOURCE_LANG, LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, :X_target_org_id FROM AR_MEMO_LINES_ALL_TL A WHERE NVL(ORG_ID, -99) = nvl(:X_source_org_id, -99) AND NOT (ORG_ID
= -3114 AND :X_target_org_id IS NOT NULL) AND NOT EXISTS ( SELECT NULL FROM AR_MEMO_LINES_ALL_TL WHERE NVL(ORG_ID, -99) =
NVL(:X_target_org_id, -99) AND MEMO_LINE_ID = A.MEMO_LINE_ID AND LANGUAGE = A.LANGUAGE)
ORA-06512: at line 9 |
|