| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Streams
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
> 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_at_gmail.com> 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_at_yahoo.com> 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
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 18 2005 - 20:49:29 CST
 |
 |