开发者

how to dubug the looping chain in synonym?

开发者 https://www.devze.com 2023-02-19 22:14 出处:网络
i have this script, when i execute this sc开发者_StackOverflow社区ript it shows the Error Messge like,

i have this script, when i execute this sc开发者_StackOverflow社区ript it shows the Error Messge like,

Error report:

SQL Error: ORA-01775: looping chain of synonyms
01775. 00000 - "looping chain of synonyms"

what can i do?

DROP TABLE ENT_OWNER.WF_REPORT_JOBQUEUE;
CREATE TABLE ENT_OWNER.WF_REPORT_JOBQUEUE
(
  ID                      NUMBER,
  WFM_ID                  NUMBER,
  EXECUTION_DATE_PLANNED  DATE,
  EXECUTION_DATE_ACTUAL   DATE,
  STATUS                  VARCHAR2(128 BYTE)
);

CREATE UNIQUE INDEX ENT_OWNER.WF_REPORT_JOBQUEUE_PK ON ENT_OWNER.WF_REPORT_JOBQUEUE
(ID);

DROP PUBLIC SYNONYM WF_REPORT_JOBQUEUE;
CREATE PUBLIC SYNONYM WF_REPORT_JOBQUEUE FOR WF_REPORT_JOBQUEUE;

ALTER TABLE ENT_OWNER.WF_REPORT_JOBQUEUE ADD (
  CONSTRAINT WF_REPORT_JOBQUEUE_PK
 PRIMARY KEY
 (ID)  USING INDEX );


GRANT DELETE, INSERT, SELECT, UPDATE ON  ENT_OWNER.WF_REPORT_JOBQUEUE TO ENT_OWNER_SELECT_ROLE;

GRANT DELETE, INSERT, SELECT, UPDATE ON  ENT_OWNER.WF_REPORT_JOBQUEUE TO ENT_OWNER_UPDATE_ROLE;

GRANT DELETE, INSERT, SELECT, UPDATE ON  ENT_OWNER.WF_REPORT_JOBQUEUE TO ENT_USER;


CREATE PUBLIC SYNONYM WF_REPORT_JOBQUEUE FOR ENT_OWNER.WF_REPORT_JOBQUEUE;

0

精彩评论

暂无评论...
验证码 换一张
取 消