Shareplex : How to check number of table replicating from particular schema
Shareplex : How to check number of table replicating from particular schema
========================================================
in my environ ment admin shema name of shareplex was SPLEX_ADM(if different in your env plz change script)
------------------------------------------------------------------------------------------------------------------
select count(*) from (
select owner, object_name, objid from SPLEX_ADM.shareplex_objmap s, dba_objects o
where s.objid = o.object_id and owner = '<Source_schemaname>' order by owner, object_name);
========================================================
in my environ ment admin shema name of shareplex was SPLEX_ADM(if different in your env plz change script)
------------------------------------------------------------------------------------------------------------------
select count(*) from (
select owner, object_name, objid from SPLEX_ADM.shareplex_objmap s, dba_objects o
where s.objid = o.object_id and owner = '<Source_schemaname>' order by owner, object_name);
Comments
Post a Comment