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

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 - 12:42:01 CDT