2020-07-08 10:32:56 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rmeis.prm: Fatal error executing DDL replication: error [Error code [955], ORA-00955: มีออบเจกต์อื่นที่ใช้ชื่อนี้แล้ว
SQL alter table "SERVICES_APP"."CLIENTUSESERVICE"
add constraint PKCLIENTUSESERVICE primary key (IDCLIENT, SERVICENAME, SERVICES, STARTDATE)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
/*
Check Constraints:
SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAMEFROMDBA_CONS_COLUMNSWHEREOWNER LIKE 'SERVICES_APP'ANDTABLE_NAME LIKE 'CLIENTUSESERVICE'
SQL> l
1 SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME
2 FROM
3 DBA_CONS_COLUMNS
4 WHERE
5 OWNER LIKE 'SERVICES_APP'
6 AND
7* TABLE_NAME LIKE 'CLIENTUSESERVICE'
SQL> /
CONSTRAINT_NAME TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------ --------------------
SYS_C0018194 CLIENTUSESERVICE IDCLIENT
SYS_C0018196 CLIENTUSESERVICE SERVICES
SYS_C0018195 CLIENTUSESERVICE SERVICENAME
FKCLIENTUSESERVICE CLIENTUSESERVICE IDCLIENT
if constraint SERVICES_APP.PKCLIENTUSESERVICE doesn't exists
check Indexes:
SELECT INDEX_NAME, TABLE_NAMEFROMDBA_INDEXESWHEREOWNER LIKE 'SERVICES_APP'ANDTABLE_NAME LIKE 'CLIENTUSESERVICE'
SQL> l
1 SELECT INDEX_NAME, TABLE_NAME
2 FROM
3 DBA_INDEXES
4 WHERE
5 OWNER LIKE 'SERVICES_APP'
6 AND
7* TABLE_NAME LIKE 'CLIENTUSESERVICE'
SQL> /
INDEX_NAME TABLE_NAME
------------------------------ ------------------------------
PKCLIENTUSESERVICE CLIENTUSESERVICE
if index SERVICES_APP.PKCLIENTUSESERVICE exists
drop index and restart Oracle Goldent Gate
DROP INDEX SERVICES_APP.PKCLIENTUSESERVICE;
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.