Home » Server Options » Replication » How to replicate the full schema?
How to replicate the full schema? [message #75309] Wed, 15 January 2003 19:35 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!
Re: How to replicate the full schema? [message #75323 is a reply to message #75309] Tue, 18 February 2003 07:56 Go to previous message
SIMONA
Messages: 3
Registered: February 2003
Junior Member
You can user the export/import utility or use(buy) ORACLE DESIGNER
With DESIGNER is complicated if you never see this product.
With exp/imp
1)You make an export of user_server1 (xxx1)
exp system/xxx file=filedmp_server1 grants=n owner=xxx1 rows=n
2)create on server2 the new user xxx2. The user xxx2 must have the role to write on the tablespace where the table's xxx1 are created. Remember to have space to create the new tables. I don't remember if you must create the new tablespace with the same name used by the table of user xxx1.
3) launch the import on server2
imp system/xxx fromuser=xxx1 touser=xxx2 ignore=y rows=n file=filedmp_server1

by
Previous Topic: I'm lost!!!!
Next Topic: Can replication be used to append to a materialized view instead of refresh
Goto Forum:
  


Current Time: Thu Nov 26 04:46:23 CST 2020