Home » Server Options » Streams & AQ » stream between two different user name (merged)
stream between two different user name (merged) [message #408185] Mon, 15 June 2009 02:28 Go to next message
narges
Messages: 11
Registered: December 2004
Junior Member
Hi
i want to replicate data drom
TEST1.TABLE1 TO TEST2.TABLE1
the user name is different in tow database when i have same username in both database it works correctly
what could i config when i have different user ?

please help me.
thx Embarassed

Report message to a moderator

Re: stream between two different user name [message #408187 is a reply to message #408185] Mon, 15 June 2009 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It works if you do it properly.
So you have a bug or a miss in your configuration, correct it.

Replication to a different schema is well explained and detailed in the documentation or Metalink depending on your version you didn't post.

Regards
Michel

Report message to a moderator

replicate between different user [message #408193 is a reply to message #408185] Mon, 15 June 2009 03:59 Go to previous messageGo to next message
narges
Messages: 11
Registered: December 2004
Junior Member
hi
i config to replicate data from
USER1.TABLE1 TO USER2.TABLE1
THE USER NAME is different in source and destination database
my config is working when users name are the same.
is there any more config?

Report message to a moderator

Re: replicate between different user [message #408207 is a reply to message #408193] Mon, 15 June 2009 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is useless to repost your question, the answer is the same.
On the other hand, you could post what we request and at first place your Oracle version (with 4 decimals).

Regards
Michel

Report message to a moderator

Re: stream between two different user name (merged) [message #408224 is a reply to message #408185] Mon, 15 June 2009 06:52 Go to previous message
narges
Messages: 11
Registered: December 2004
Junior Member
thx for your reply.
sorry i have an internet problem that cause this rpost.
my oracle database version is: 10.2.0.1
os:windows
and my config you could see in attch file.

[Updated on: Mon, 15 June 2009 23:18]

Report message to a moderator

Previous Topic: Table not in sync in bi-directional streams replication
Next Topic: Stream implemetation - general view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 01 07:41:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.