Re: Copying Tables between Databases using SQL ???

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