Hi List, I am getting ORA-23394: duplicate propagator, but when I execute DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR, it says ORA-23357: the propagator does not exist.
How do i resolve this issue? Anyhelp would be really greatful. Kindly see below ================= SQL> connect system/[EMAIL PROTECTED] Connected. SQL> BEGIN 2 DBMS_DEFER_SYS.REGISTER_PROPAGATOR ( 3 username => 'repadmin'); 4 END; 5 / BEGIN * ERROR at line 1: ORA-23394: duplicate propagator ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYSTEM.DEF$_PROPAGATOR_TRIG", line 9 ORA-04088: error during execution of trigger 'SYSTEM.DEF$_PROPAGATOR_TRIG' ORA-06512: at "SYS.DBMS_DEFER_INTERNAL_SYS", line 1572 ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2460 ORA-06512: at line 2 SQL> BEGIN 2 DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR ( 3 username=> 'repadmin'); 4 END; 5 / BEGIN * ERROR at line 1: ORA-23357: the propagator does not exist ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2508 ORA-06512: at line 2 How do i resolve this issue? Anyhelp would be really greatful. Thanks in advance, __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).