RE: Data Pump over NETWORK_LINK

Pardon me, but in a recent move from Windoze to HP-UX data pump happily moved 
longs, blobs, clobs, etc with no problem over a db link. 


Dick Goulet
Senior Oracle DBA
PAREXEL International

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jakub Wartak
Sent: Tuesday, April 21, 2009 2:52 AM
To: oracle-l@xxxxxxxxxxxxx; Roger.Xu@xxxxxxxx
Subject: Re: Data Pump over NETWORK_LINK

Dnia poniedziałek, 20 kwietnia 2009 22:05, Xu, Roger napisał:
[..]
> Now my question is: how do I do this over the NETWORK_LINK? What kind of
> DB link I need?

Also be sure that you don't have unsupported types for db links (LONG, LONG 
RAW, etc.) in source database, as the DataPump will fail in the middle when 
it comes to them (because Oracle sucks when it comes supporting all it's own 
datatypes..., e.g. some versions of Siebel like to store LONGs. Maybe they 
will fix that in 14gR2 ;) ).

-- 
Jakub Wartak
http://vnull.pcnet.com.pl
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Other related posts: