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

Comments

Popular posts from this blog

SQL Tuning Task Creation ORA-13780: SQL statement does not exist.

Shareplex some commands

ORA-1092 : opitsk aborting process