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

Since you have two different servers why not create a database link using the Database link command and then using a normal select (one of the tables will be accessed remotely) you could push in the data.

OR else if you know Powerbuilder then you can create two transaction objects and use pipeline to do the job.

Thanks

In article <01be8b55$03280cf0$12f21cac_at_dspaisman>,   "David Spaisman" <david.spaisman_at_compaq.com> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 20:07:51 CDT