| 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.
![]() |
![]() |