Re: Oracle Streams
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: mishra.sanjay@xxxxxxxxx
- Date: Tue, 18 Jan 2005 09:48:31 -0800 (PST)
Sanjay
I know that you are truly guru of several Oracle stuff
like Streams. Finally after reinstalling Oracle, I had
created the Replication env using 9.2.0.5 and then
apply patch to 9.2.0.6. Now everything works. Thanks
for your email.
I still had one question. How can I disable current
session to not send the changes to other server. In
Advance replication we use
dbms_reputil.replication_off and all changes in that
session are not replicated.
Actually I had to use it in the following schenario,
I had to create the sequecnes with different starting
value on DB1 and DB2. Now If I am creating on DB1, it
will passed as such to DB2 and as it is two way
replication setup and so is the problem.
Also I need to create some cron job that should delete
some 30 days old data from some of the table and so
don't want to put load on the network and want to run
independent Job on both server. This way I will make
the failover easy.
Thanks for your kind consideration and time
--- Sanjay Mishra <mishra.sanjay@xxxxxxxxx> wrote:
> Which version/release of Oracle are you on?
> Are you setting up Streams with multiple
> destinations?
> During which step of the setup do you get the error?
> Have you completed all the preceding steps error
> free?
> Can you copy+paste the statement you are executing
> that causes an error.
>
> Coincidentally yours,
> Sanjay Mishra
>
>
> On Sat, 8 Jan 2005 09:31:50 -0600, Sanjay Mishra
> <mishra.sanjay@xxxxxxxxx> wrote:
> > Which version/release of Oracle are you on?
> > Are you setting up Streams with multiple
> destinations?
> > During which step of the setup do you get the
> error?
> > Have you completed all the preceding steps error
> free?
> > Can you copy+paste the statement you are executing
> that causes an error.
> >
> > Coincidentally yours,
> > Sanjay Mishra
> >
> > On Fri, 7 Jan 2005 07:23:27 -0800 (PST), Sanjay
> Mishra
> > <smishra_97@xxxxxxxxx> wrote:
> > > Dear Experts
> > >
> > > I am trying to setup Streams and getting some
> weired
> > > Error. I tried to use OEM, but its wizard also
> fails
> > > with the same ORA-25238. I don't know where I
> need to
> > > reduce the Recepient.
> > >
> > > Any Idea. I am trying to configure Streams for A
> > > schema by taking 20 tables.
> > >
> > > TIA for any ideas on the above error
> > >
> > > Sanjay
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Mail - 250MB free storage. Do more.
> Manage less.
> > > http://info.mail.yahoo.com/mail_250
> > > --
> > > //www.freelists.org/webpage/oracle-l
> > >
> >
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
