select sname,oname,status,gname from dba_repobject where gname='SCOTT_REPG';
结果:
sname oname status gname
SCOTT DEPT VALID SCOTT_REPG
SCOTT DEPT$RP VALID SCOTT_REPG
SCOTT DEPT$RP VALID SCOTT_REPG
SCOTT EMP VALID SCOTT_REPG
SCOTT EMP$RP VALID SCOTT_REPG
SCOTT EMP$RP VALID SCOTT_REPG
select gname, dblink, masterdef MASTERDEF, master MASTER from sys.dba_repsites where gname='SCOTT_REPG';
结果:
gname dblink masterdef master
SCOTT_REPG ORC33.WORLD N Y
SCOTT_REPG ORC22.WORLD Y Y
select gname,master,status from dba_repgroup where gname='SCOTT_REPG';
结果:
gname master status
SCOTT_REPG Y NORMAL