Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Student Seeking Help with Oracle
It's been a little while, but the basics are
create database link MYLINK
connect to USER identified by PASSWORD
using 'TNSNAMES_ENTRY';
/
create table WHATEVER as select * from WHATEVER_at_MYLINK;
That will create a local table as a copy of a remote table, data and all.
Is that what you wanted?
-Dean
On 23 Mar 1999 00:30:02 GMT, "Jim" <lermontovb_at_hotmail.com> wrote:
>
>
>Peter Webb <Peter.Webb_at_cern.ch> wrote in article
><36F678E0.1A97AC94_at_cern.ch>...
>> I'm currently working on project, and I'm interested in finding out
>> whether or not it is technically possible to create a table, with fields
>> which are linked to a table within another database.
>>
>> Is it possible? Any help would be appreciated!
>>
>> Peter.
>>
>
>It's definetly possible - you should look at creating a database link
>(can't help with the syntax right now I'm afraid - all my Oracle books are
>in work)
>Jim
Received on Thu Mar 25 1999 - 20:19:02 CST