Oracle: Determining if a Table is Replicated
Query:
Select Oname, Sname
from dba_repobject
where Oname IN ('DISPATCH_QUEUE','CONTRACT');
Results:
| ONAME | SNAME |
| CONTRACT | PROD |
CONTRACT table is replicated, but the DISPATCH_QUEUE table is not.
Jason's Rant...I mean Blog
Query:
Select Oname, Sname
from dba_repobject
where Oname IN ('DISPATCH_QUEUE','CONTRACT');
Results:
| ONAME | SNAME |
| CONTRACT | PROD |
CONTRACT table is replicated, but the DISPATCH_QUEUE table is not.
No comments:
Post a Comment