Re: copy data

From: gazzag <gareth_at_jamms.org>
Date: 15 Mar 2006 03:32:26 -0800
Message-ID: <1142422346.016688.174390@i40g2000cwc.googlegroups.com>

Shredder wrote:
> I have 2 databases on an oracle 8i server running NetWare 5.1. They are
> duplicate databases as far as structure. The has data that is about 8
> months older than the other. How can I copy data from one to the other.
> Example;
>
> I need to update the stock table on db2 database with the stock table on
> db1.

Export the STOCK table from DB1:

Truncate the STOCK table on DB2

Import the export from DB1 into DB2 with the "ignore=y" parameter.

HTH -g Received on Wed Mar 15 2006 - 05:32:26 CST