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

View running queries in postgresql

 View running queries in postgreSQL: SELECT * FROM pg_stat_activity;