Home » Server Options » Replication » Replicate "Security management tables"
Replicate "Security management tables" [message #241411] Tue, 29 May 2007 08:56 Go to next message
mic1312
Messages: 3
Registered: May 2007
Location: Belgium
Junior Member
Hello,

I would like replicate the objects Users, Roles and Profiles from
the subtree Security to normal tables in a new database.

The goal is to have this object in a replicated database under a diferent view and change this elements in the view.
With this solution, I can change this element with a program not executed directly on the system Oracle.


How can I do this??

Thank you.
Re: Replicate "Security management tables" [message #241859 is a reply to message #241411] Wed, 30 May 2007 14:30 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
You can try export/import utility.
Re: Replicate "Security management tables" [message #241931 is a reply to message #241411] Thu, 31 May 2007 01:59 Go to previous messageGo to next message
mic1312
Messages: 3
Registered: May 2007
Location: Belgium
Junior Member
The problem is that the changes made in the replicated database must be also automaticaly done in the first database.

Re: Replicate "Security management tables" [message #242126 is a reply to message #241931] Thu, 31 May 2007 13:46 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
You may implement either Oracle Streams or Quest shareplex...both are bidirectional so you may get your data updated on both direction.
Re: Replicate "Security management tables" [message #242629 is a reply to message #242126] Mon, 04 June 2007 07:43 Go to previous message
mic1312
Messages: 3
Registered: May 2007
Location: Belgium
Junior Member
Thanks for your help.
I will find about the streams because i don't know anything on the streams.
Previous Topic: how can i see number of dblinks from the server side
Next Topic: Replication Sequence
Goto Forum:
  


Current Time: Thu Mar 28 14:20:13 CDT 2024