--- for port 2200 --- select owner, object_name, objid from splex.shareplex_objmap s, dba_objects o where s.objid = o.object_id order by owner, object_name; --- for port 2201 ---- select owner, object_name, objid from splex_cpf.shareplex_objmap s, dba_objects o where s.objid = o.object_id order by owner, object_name;
Tuesday, February 22, 2011
Tip - List all of the tables in the Shareplex replication
Some time ago a co-worker showed me how to do this with a query. Today I have a need to do it, but I forget. I have to get the table list from the configuration file. Now I blog this as a reference for future:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment