| How to replicate the full schema? [message #75309] |
Wed, 15 January 2003 19:35  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
