Re: Clone a table to a new table on different db/server wth only two columns

On 20 Apr 1999 17:42:01 GMT, "David Spaisman" <david.spaisman_at_compaq.com> wrote:

>Actually I need to create a new table of only two columns on a database on
>a different server. But the problem comes since I need to copy the data.
>
>Here's the situation: I need to copy the data for two columns from the
>existing table on a different database on a different server to a new table
>on a different database on a different server. The column names on the new
>table are different from the column names on the existing table on the
>different server but the data types are the same.

Probably the easiest way is to create a database link between the two databases and then use a

CREATE TABLE AS SELECT... statement. Look up the syntax for CREATE DATABASE LINK in your SQL Reference manual. Received on Wed Apr 21 1999 - 02:12:46 CDT