My method works fine. I opened a standby database read only and then from the primary : TESTDB> create database link rotest using 'rotest'; Database link created. TESTDB> insert into finn select * from finn@rotest; 1 row created. TESTDB> commit; Commit complete. Finn On Thu, Aug 28, 2008 at 11:17 AM, Powell, Mark D <mark.powell@xxxxxxx> wrote: > > Distributed transactions take DX locks and use undo entries .... -- //www.freelists.org/webpage/oracle-l