| where to create dblink? [message #587805] |
Tue, 18 June 2013 14:32  |
lg123
Messages: 225
Registered: August 2008
|
Senior Member |
|
|
Usually where should we create the database link? In the production or development?
Literally speaking, where should we give this command?
create public database link dblinkname connect to user_in_db2 identified by password_in_db2 using 'tnsentry name in db2';
In production or development? Please suggest.
|
|
|
|
| Re: where to create dblink? [message #587815 is a reply to message #587805] |
Tue, 18 June 2013 15:09  |
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
I would never link the two, nor would most people. If you want to pull data back from prod to dev, use export or datapump, if not what are you trying to do?
|
|
|
|
| Re: where to create dblink? [message #587816 is a reply to message #587805] |
Tue, 18 June 2013 15:16 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
I hesitate to answer because of the very reason cookiemonster gave, think of a database link is as one-way link. The source can interact with the destination.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
