It is possible to do so. The SharePlex internal table SHAREPLEX_OBJMAP ON on the source database contains the list of tables that are currently in replication or have been in replication in the past. It only lists out such tables by OBJECT_ID value and not by name. To list them by name, one may need to get the info from the DBA_OBJECTS view by writing a join query. Here is a sample illustration for simply getting the object ids:
SQL> select * from shareplex_objmap;
OBJID START_ACTID END_ACTID DONE
---------- ----------- ---------- ----------
997879 39 39 1
997880 39 39 1
998159 39 39 1
3 rows selected.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center