Home » Server Options » Replication » Replication of functions and views
Replication of functions and views [message #75210] Thu, 11 July 2002 17:05 Go to next message
Diego
Messages: 7
Registered: August 2000
Junior Member
How to replication function and views on database 9i
Re: Replication of functions and views [message #75214 is a reply to message #75210] Sun, 21 July 2002 17:23 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
Diego,
I suggest that it is not a good idea to replicate DDL between databases. I would not want to end up replicating any type of dangerous activity like a DROP command. I have confirmed this with instructors from Oracle Education who have told me that most DBAs just replicate the data between the systems, and manually run the DDL commands on each replicated site.

You may find the following sample replication setup scripts to be helpful:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html

David Simpson
www.dotcomsolutionsinc.net
Previous Topic: Query
Next Topic: Changing Master Definition Site
Goto Forum:
  


Current Time: Tue Jul 14 19:48:09 CDT 2020