where to create dblink? [message #587805] |
Tue, 18 June 2013 14:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|