I think, you will need to install the Oracle's Distributed Option to do it.
Not sure if licensing is an issue here, as I noticed that since 7.33, it was
installed automatically, but I recalled somewhere that it is a chargeable
option.
Clyde Tarver wrote in message <35FBA9AA.75FF3AB4_at_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 Mon Sep 14 1998 - 09:05:44 CDT
