Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_IJOB error w/ replication
Hi,
Our updateable snapshots are failing to replicate properly since the background job is failing.
When run from SQL*Plus, I get the following error message:
begin dbms_job.run(job=>104); end;
*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed ORA-06512: at "SYS.DBMS_IJOB", line 242 ORA-06512: at "SYS.DBMS_JOB", line 218 ORA-06512: at line 1
However, if I run the text of the job (i.e. dbms_refresh.refresh("'REPADMIN"."REPLTEST_UPD'");) everything works.
We are running replication (1 master site and 1 replication site) with 7.3.3.0.0. Our readonly snapshots work fine.
Ideas? Security related?
Thanks in advance.
![]() |
![]() |