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.
|
|
|