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,

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?




http://www.freelists.org/webpage/oracle-l Received on Mon Jan 31 2011 - 15:45:51 CST

Original text of this message