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);

No comments:

Post a Comment

Common Oracle Clusterware crsctl commands

  Oracle Clusterware crsctl commands: # Check cluster status crsctl check crs crsctl check cluster # Cluster resources crsctl status reso...