Is it possible to create a databse link on a table in a remote database?
Lets say there is a table A in schema B in a remote databse DEV1.
Is it possible to create a databse link poiting to table A from databse called DEV2? Is yes, how? Thanks.
Printable View
Is it possible to create a databse link on a table in a remote database?
Lets say there is a table A in schema B in a remote databse DEV1.
Is it possible to create a databse link poiting to table A from databse called DEV2? Is yes, how? Thanks.
Of course dear :) ,....create it just d same as u create an ordinary
dblink on a separate local server using 'service.name' in tnsnames.ora
Is this what you are talking about?Quote:
Originally Posted by yxez
create databse link dl_dev1 connect to schema identified by password using 'DEV1';
yes pco....dev1 just points out to the remote ip address of the server ;)
well done for missing the point of the question, he wants to create a dblink to a specific table.Quote:
Originally Posted by yxez
Can do that - best option would be to create a synonym for a table@and dont give the users access to the dblink in total
Davey is double right, also you can restrict the users from what DML's they can use on the table.Quote:
Originally Posted by davey23uk
On security side, giving access to dblink in total, have full access to all the objects in that schema may be fatal.
oh pco is already aware of that :D , coz he knew how to create dblinks
locally...what he is after is if it works on remote too....don't u pico? :p