I’m in process of migrating eight 8.1.7 (old server) databases to 10gR2 (new server). These are fairly small database, but has lots of dblinks and synonyms. What would best approach to do it? Any suggestion would be greatly appreciate it.
Thanks!
Printable View
I’m in process of migrating eight 8.1.7 (old server) databases to 10gR2 (new server). These are fairly small database, but has lots of dblinks and synonyms. What would best approach to do it? Any suggestion would be greatly appreciate it.
Thanks!
I suppose you can afford a small downtime.
1- Create new 10g database in new server.
2- Do a full export on 8.1.7
3- Do a full import on 10g
4- Update TNSNAMES.ora file on 10g box to match what you have on 8.1.7 box
5- Test dblinks
Relax and enjoy.
Thanks PAVB! That what I was planing. But not sure ......Export/Import will also take care the link and synonyms or I have manually create it?
everything will move, even Public Synonyms and Public DBLinks if you do full exp/imp