Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copying Tables between Databases using SQL ???

Re: Copying Tables between Databases using SQL ???

From: Clyde Tarver <ctarver_at_america.net>
Date: Sun, 13 Sep 1998 15:20:06 GMT
Message-ID: <35FBA9AA.75FF3AB4@america.net>


Create a database link thta points to the desired database instance Then you can do this...

insert into tablename (a local database table) (

    col1,
....

)
SELECT
....

FROM tablename_at_dblinkname
WHERE
    ...;

You can do this with just about any valid SQL statement. Received on Sun Sep 13 1998 - 10:20:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US