Home » RDBMS Server » Server Administration » How to replicate the whold schema automaticly?
How to replicate the whold schema automaticly? [message #55289] Wed, 15 January 2003 22:23 Go to next message
oracle8i
Messages: 16
Registered: October 2002
Junior Member
Now I have two servers installed with oracle 8.1.7. I want to replicate server1's schema "user1" to server2's same schema automaticly. How can I realize this goal?
Thanks!

Report message to a moderator

Re: How to replicate the whold schema automaticly? [message #55360 is a reply to message #55289] Mon, 20 January 2003 11:53 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Three ways come to mind:

1. Snapshot replication for all tables in schema 1 to schema2.

2. Schema export from schema1, disable constraints, triggers, truncate tables in schema 2, import into schema2. Easy to script all this will shell or batch scripts.

3. Move schema1 objects in single table space or at least make sure the current tablespaces are selfcontaint. Then script transportable tablespaces for schema1, import the meta data into schema2, and copy the tablespaces. Easy to do too and much much faster since you stay on the same machine...

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: forget password
Next Topic: Oracle privileges
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 00:32:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.