This content has been marked as final. Show 4 replies
which version and os?
in 11gr2 there is a bug, check MOS:
Bug 9775678: ORA-00001: UNIQUE CONSTRAINT (SYS.WRI$_ADV_SQLT_PLANS_PK) VIOLATED
may you have to open a service request with reference to this bug.
check this http://translate.google.co.in/translate?hl=en&sl=ko&u=http://kr.forums.oracle.com/forums/thread.jspa%3FthreadID%3D952867&ei=v3_hTPP4LYmxcbT-vZcM&sa=X&oi=translate&ct=result&resnum=2&ved=0CCYQ7gEwAQ&prev=/search%3Fq%3DSYS.WRI%2524_ADV_SQLT_PLANS_PK%26hl%3Den%26client%3Dfirefox-a%26rls%3Dorg.mozilla:en-US:official%26prmd%3Div
I saw that thread, but this is the auto task, rather than one I created manually, so I wasn't sure it was relevant.
That is my version, so I'll investigate the bug route. Was there a patch/fix?
22.214.171.124 update seems to have resolved this, fyi.