Re: Clone table to a new table on different db and server with only two columns

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Tue, 20 Apr 1999 18:22:52 GMT
Message-ID: <371CC6D8.A2352F31@sympatico.ca>

Three solutions :

• Use SQL*Plus COPY command. You'll be able to copy from one db to another.
• Spool the output of the SELECT of the two desired columns to disk, FTP the file to the other server, use SQL*Loader to reload data to new table.
• CREATE AS SELECT a table on server1 with the proper column names required on server2. Then Export/Import. Something like : CREATE TABLE NEW_TABLE AS SELECT COL1 NEW_COL1_NAME, COL2 NEW_COL2_NAME FROM ORIGINAL_TABLE;

SQL*Plus copy is slower but does not require as many steps.

Regards,

Marc Mazerolle
InforMaze Technologies

David Spaisman wrote:

> Hello:
>
> I am working on Oracle 8.0.4 on NT 4.0, sp4.
>
> 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.
>
> The business analyst needs this table(different column names) in a
> different application but the data is exactly what's needed.
>
> I am not sure how to do this.I am not sure export/import will work even
> after I clone the table on either side because of the different table names
>
> Can any furnish some ideas on how to do this?
>
> Thanks.
>
> David Spaisman
Received on Tue Apr 20 1999 - 13:22:52 CDT