Re: ???? Datapump between 2 Oracle servers, does it exist????

ilepper wrote:
>
> Hello,
>
> We've got 2 database servers, 7.3 and 8.16.
> Once a week we like to import data from 7.3 to 8.16 Oracle server.
> But we dont want all the records from the 7.3 server, so a where clause
> is needed.
>
> We used to use a databaselink between the servers, back in the old days
> that we also used 7.3. (We imported the data with sql queries.)
>
> But now the databaselink doesnt work anymore, and with oracle sql queries
> you cant connect to more then 1 instance at a time.
>
> So are there any datapump tools?
> I could make something in Delphi but I rather not.
>
> thanks
>
> Ido de Lepper
> ilepper_at_fbk.eur.nl

8i supports a where-clause on export so you could try running the 8i version using sqlnet to get to the 7.3 data.

BTW, database links can work across versions ...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse