Oracle Streams and Uniqueness
Date: Mon, 10 Nov 2008 14:21:10 +0000
Message-ID: <7765c8970811100621l24296ca3m16f399f689fe1b81@mail.gmail.com>
All,
I am being told by a support analyst at Oracle re Streams that
Oracle must be able to identify uniquely and match corresponding rows at
different
databases.
So each table in a Streams environment should have a primary key, unique key
constraints or a substitute key.
This in addition to supplemental logging. Is this correct? If so, surely this implies that streams is only useful in environments where tables are guaranteed (by Oracle or the application(s) running against it) to be unique. This seems a somewhat significant real-world disadvantage to me, based on the applications that I see. I guess I sort of hoped that Oracle might have used the ROWID to generated the LCR (in a way that I fully admit I have spend no time at all thinking about).
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 10 2008 - 08:21:10 CST