OraFAQ Forum: Replication » dbms_refresh.refresh does not update secondary DB

Home » Server Options » Replication » dbms_refresh.refresh does not update secondary DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_refresh.refresh does not update secondary DB [message #15397]

Wed, 06 October 2004 05:34

marco
Messages: 46
Registered: March 2001

Member

I have got a primary DB (PIN1)where I perform an update on PLAN_T table and a secondary DB (PIN2) �

I tried to launch :

sqlplus pin2/pin2@PIN2

SQL>execute dbms_refresh.refresh('"PIN2"."PRICE"');

PL/SQL procedure successfully completed.

But no�update is done.

Entries�in��dba_jobs are:

SQL> select what||'|'||job from dba_jobs;

WHAT||'|'||JOB

--------------------------------------------------------------------------------

dbms_refresh.refresh('"PIN2"."CONFIG"');&#55353;&#56549;

dbms_refresh.refresh('"PIN2"."PRICE"');&#55353;&#56556;

dbms_refresh.refresh('"PIN2"."GENERAL"');&#55353;&#56551;

I also tried�to launch directly��

SQL>execute dbms_job.run(140);�

PL/SQL procedure successfully completed.

but no update is done.

�

Report message to a moderator

Previous Topic:	Database link active but could not be able to resolve object resolution
Next Topic:	delete bulk rows from table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 31 07:43:51 CDT 2025