SQL Loader and Streams
From: mohammed bhatti <mohammed.bhatti1_at_gmail.com>
Date: Mon, 31 Jan 2011 16:45:51 -0500
Message-ID: <AANLkTinZM_eVPEpdACH6vPVmAN0zDeN0V=xJfuBqLUTs_at_mail.gmail.com>
Hi All,
Date: Mon, 31 Jan 2011 16:45:51 -0500
Message-ID: <AANLkTinZM_eVPEpdACH6vPVmAN0zDeN0V=xJfuBqLUTs_at_mail.gmail.com>
Hi All,
On Oracle 10gR2, RHAS 4u7, running a multimaster streams setup.
So I have a two databases replicating to each other via streams. I'm trying to figure out a way to load data using SQL*Loader into one of the databases without the data getting replicated to the other site. I was thinking I could set a tag for the sqlldr data so that I could exclude these from getting replicated but not sure how this could be done. My streams are setup so that tagged values are excluded. Any ideas?
--
mohammed
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 31 2011 - 15:45:51 CST