RE: Data Pump over NETWORK_LINK
Date: Tue, 21 Apr 2009 09:46:57 -0400
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.
Senior Oracle DBA
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-lReceived on Tue Apr 21 2009 - 08:46:57 CDT