Home » Server Options » Replication » dbms_refresh.refresh does not update secondary DB
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"');��

dbms_refresh.refresh('"PIN2"."PRICE"');��

dbms_refresh.refresh('"PIN2"."GENERAL"');��

I also tried to launch directly  

SQL>execute dbms_job.run(140); 

PL/SQL procedure successfully completed.

but no update is done.

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


Current Time: Thu Mar 28 16:28:58 CDT 2024