| data migration [message #185747] |
Thu, 03 August 2006 07:13  |
helloanam
Messages: 20
Registered: August 2005
|
Junior Member |
|
|
i just want any kind of help regarding making "Scripts" which are used in data migration. These scripts have to perform all the tasks of data migratin from one DB to another and we also have to verify its correctness.
Any help is appreciable.
|
|
|
|
|
|
| Re: data migration [message #185849 is a reply to message #185798] |
Thu, 03 August 2006 17:38  |
helloanam
Messages: 20
Registered: August 2005
|
Junior Member |
|
|
i am talking abt oracle 9i. its the req to migrate data by scripts which can be run any time just by changing names of dbs and it performs all the tasks automatically.
is it possible to write an export and import script?
if yes then can any one help me?
|
|
|
|
|
|
| Re: data migration [message #185918 is a reply to message #185877] |
Fri, 04 August 2006 04:37 |
angelsliu
Messages: 23
Registered: July 2006
|
Junior Member |
|
|
| Littlefoot wrote on Fri, 04 August 2006 00:18 |
I see; if those databases are in the same network, perhaps you could consider using materialized views instead of copying data between databases. They can be refreshed whenever you wish, without writing any scripts.
|
maybe clone is best practise
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
