Home » Server Options » Streams & AQ » Is it possible to use streams in two schema in same database?
Is it possible to use streams in two schema in same database? [message #381237] Thu, 15 January 2009 23:49 Go to next message
amitchhabra1981
Messages: 12
Registered: December 2008
Location: NOIDA
Junior Member
If someone know is it possible to use streams between two schemas in same database than please let me know the steps to setup the streams.


Regards,
Amit Chhabra Confused
Re: Is it possible to use streams in two schema in same database? [message #381266 is a reply to message #381237] Fri, 16 January 2009 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try following the steps for different databases?

Regards
Michel
Re: Is it possible to use streams in two schema in same database? [message #381309 is a reply to message #381266] Fri, 16 January 2009 04:40 Go to previous messageGo to next message
amitchhabra1981
Messages: 12
Registered: December 2008
Location: NOIDA
Junior Member
yes i tried now i can replicate the data between two database but now requrement is such that i have to replicate the data in same database.


Regards,
Amit Chhabra
Re: Is it possible to use streams in two schema in same database? [message #381331 is a reply to message #381309] Fri, 16 January 2009 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And did you try it in a single database?

Regards
Michel
Re: Is it possible to use streams in two schema in same database? [message #381350 is a reply to message #381331] Fri, 16 January 2009 08:00 Go to previous messageGo to next message
amitchhabra1981
Messages: 12
Registered: December 2008
Location: NOIDA
Junior Member
yes i tried but i am not able to replicate changes.


Regards,
Amit Chhabra
Re: Is it possible to use streams in two schema in same database? [message #381355 is a reply to message #381350] Fri, 16 January 2009 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
That is you created all objects, started capture, propagation and apply processes without any error and no modification are replicated?

Regards
Michel
Re: Is it possible to use streams in two schema in same database? [message #381612 is a reply to message #381355] Mon, 19 January 2009 00:05 Go to previous messageGo to next message
amitchhabra1981
Messages: 12
Registered: December 2008
Location: NOIDA
Junior Member
yes

Regards,
Amit Chhabra
Re: Is it possible to use streams in two schema in same database? [message #381737 is a reply to message #381612] Mon, 19 January 2009 10:09 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Did you do instantiation of the objects after that.
Regards,
Varun Punj,
Previous Topic: 10g Release 2 Streams Replication
Next Topic: OS compatabilities in streams
Goto Forum:
  


Current Time: Thu Mar 28 12:58:47 CDT 2024