Databse link on a table

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

Quote:

---

Originally Posted by yxez

Of course dear,....create it just 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?

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 ;)

Quote:

---

Originally Posted by yxez

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.

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

Quote:

---

Originally Posted by davey23uk

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.

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