Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_IJOB error w/ replication

DBMS_IJOB error w/ replication

From: Aric Rosenbaum <aricr_at_arconsultinginc.com>
Date: Fri, 23 Oct 1998 15:51:51 -0400
Message-ID: <3630DE57.556C1947@arconsultinginc.com>


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.

Received on Fri Oct 23 1998 - 14:51:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US