Re: copy data

From: Shredder <shred_at_shredder.com>
Date: Wed, 15 Mar 2006 13:21:58 GMT
Message-ID: <WxURf.14383$g91.12782@tornado.ohiordc.rr.com>

"gazzag" <gareth_at_jamms.org> wrote in message news:1142422346.016688.174390_at_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
>

Sorry, I'm pretty green at this. Would my SQL look like this ....

connected to db1
export * from stock
truncate stock
connected to db2
import ???

How would I specify a target for the export? Received on Wed Mar 15 2006 - 07:21:58 CST