Home » Server Options » Replication » when config my adv replication,met an error,pls see and help me
when config my adv replication,met an error,pls see and help me [message #181683] Tue, 11 July 2006 02:29 Go to next message
angelsliu
Messages: 23
Registered: July 2006
Junior Member
exec dbms_defer_sys.schedule_purge(next_date=>sysdate,interval=>'sysdate+1/
24',delay_seconds=>0,rollback_segment=>'');
BEGIN dbms_defer_sys.schedule_purge(next_date=>sysdate,interval=>'sysdate+1/24',
delay_seconds=>0,rollback_segment=>''); END;

*
ERROR at line 1:
ORA-23421: job number 1 is not a job in the job queue
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 3010
ORA-06512: at line 1


and I select * from dba-jobs

SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     10


SQL> select job, log_user, what from dba_jobs
  2  ;

       JOB LOG_USER
---------- ------------------------------
WHAT
--------------------------------------------------------------------------------

         1 SYS
declare rc binary_integer; begin rc := sys.dbms_defer_sys.purge( delay_seconds=>

0); end;

         2 REPADMIN
declare rc binary_integer; begin rc := sys.dbms_defer_sys.push(destination=>'REP

2.COM'); end;

         3 REPADMIN

       JOB LOG_USER
---------- ------------------------------
WHAT
--------------------------------------------------------------------------------

dbms_repcat.do_deferred_repcat_admin('"SCOTT_REPG"', FALSE);

         4 REPADMIN
declare rc binary_integer; begin rc := sys.dbms_defer_sys.push(destination=>'SCO

TT_REPG'); end;

Re: when config my adv replication,met an error,pls see and help me [message #181789 is a reply to message #181683] Tue, 11 July 2006 09:00 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Job 1 should belong to the REPADMIN users, not to SYS.
Previous Topic: HELP on replication setup
Next Topic: oracle won't allow fast refresh materialized view with union
Goto Forum:
  


Current Time: Thu Mar 28 08:47:19 CDT 2024