| remote database migration [message #644018] |
Mon, 26 October 2015 04:12  |
 |
deb171100
Messages: 7
Registered: October 2015
|
Junior Member |
|
|
Our remote database is now going to be moved to a new location. The remote tables are accessed via dblink. The materalized view exists in our local db and is referencing the tables thru db link.
Can you please advise if any points are missing.
Connectivity needs to be established with new remote db
dblink need to be dropped and re created to use new db link
TNS entry should be modified in local tnsnames.ora.
**should be existing remote db.
[Updated on: Mon, 26 October 2015 04:18] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: remote database migration [message #644029 is a reply to message #644020] |
Mon, 26 October 2015 06:46  |
 |
EdStevens
Messages: 1377
Registered: September 2013
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 26 October 2015 04:19
You don't need to recreate the dblink, just modify the tnsnames.ora to point to the new database.
That would depend on how the db link is defined in the first place. If it is defined to use a tnsnames reference, then true. But if it is defined with a hard-coded connection string, then it would need to be re-defined. And hopefully that redefinition would be to use tnsnames entry.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
