darkbishop
Дата: 25.11.2009 16:35:40
Доброго времени суток всем, помогите найти проёб в скрипте по простой репликации, которая ну никак не хочет работать:
на стороне db1:
drop database link db2_link
CREATE DATABASE LINK db1_link CONNECT TO repad IDENTIFIED BY repad;
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
next_date => sysdate,
interval => 'sysdate+1/24/30',
delay_seconds => 0);
END;
/
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => 'db2_link',
interval => 'SYSDATE + (1/24/60)',
next_date => SYSDATE,
stop_on_error => FALSE,
parallelism => 1,
delay_seconds => 0);
END;
/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP (
gname => 'rg');
END;
/
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
gname => 'rg',
type => 'TABLE',
oname => 'abon_port',
sname => 'shema',
use_existing_object => TRUE,
copy_rows => true);
END;
/
BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE (
gname => 'rg',
master => 'db2_link',
use_existing_objects => TRUE,
copy_rows => true,
propagation_mode => 'ASYNCHRONOUS');
END;
/
BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'shema',
oname => 'abon_port',
type => 'TABLE',
min_communication => TRUE);
END;
/
BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY (
gname => 'rg');
END;
/
на стороне db2:
CREATE DATABASE LINK db1_link CONNECT TO repad IDENTIFIED BY repad;
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => 'db1_link',
interval => 'SYSDATE + (1/24/60)',
next_date => SYSDATE,
stop_on_error => FALSE,
parallelism => 1,
delay_seconds => 0);
END;
/
обе базы 10.2.0.4
заранее спасибо