Tuesday, March 16, 2010

Oracle: Determining if a Table is Replicated

Query:

Select Oname, Sname 
from dba_repobject 
where Oname IN ('DISPATCH_QUEUE','CONTRACT');
Results:
ONAMESNAME
CONTRACTPROD
The CONTRACT table is replicated, but the DISPATCH_QUEUE table is not.

No comments: