Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I access remote tables?
CREATE PUBLIC DATABASE LINK remote
CONNECT TO scott IDENTIFIED BY tiger
USING '<instance name from tnsnames.ora file>';
hth
jerry gitomer
Henrik Otto wrote in message <381D940D.5EED_at_space.se>...
>Hello,
>I wonder how I can access a table in another schema for selects
easily.
>I dont want to alter the priviliges for the table. I'd like to
do
>something like: select name from table_name_at_other_schema. I've
tried
>to create a database link but I dont know what to put in the
>connect-string clause. Any help is appreciated.
>
>Henrik
Received on Mon Nov 01 1999 - 11:01:02 CST