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

You could use Oracle Snapshots to replicate the table to the second machine, depending upon requirements of the second machine. ( Read Only or Updateable or Each Way replication).

This would use SQL*Net to get the data to the second machine, and when you create the Snapshot on the second machine, the columns can be different names (hence supporting the Business Analyst needs).

With Snapshots, you can automate the refresh of the Snapshot with the DBMS_REFRESH package which runs under as a Job under Oracle Job Queue systems.

Hope this helps David,

Andrew

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 - 20:31:37 CDT