RE: Data Pump over NETWORK_LINK

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Tue, 21 Apr 2009 09:46:57 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F272E2230_at_US-BOS-MX011.na.pxl.int>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jakub Wartak Sent: Tuesday, April 21, 2009 2:52 AM
To: oracle-l_at_freelists.org; Roger.Xu_at_dpsg.com 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

Received on Tue Apr 21 2009 - 08:46:57 CDT