Re: Copying table from one database to another db which have long raw column & huge data

From: Raja Subramaniyan <raja.s28_at_gmail.com>
Date: Tue, 23 Apr 2013 11:39:24 +0530
Message-ID: <CACxKW=S9zZcOetC+3gHVoJvgsCTZ6RnbKS+rydvW6JAyp_WpWA_at_mail.gmail.com>

Thanks Alan. I am preferring exp / expdp methods to proceed. Please let me know if there any constraints for using that for LONG RAW DType. Regards,
Raja.S

On Tue, Apr 23, 2013 at 10:45 AM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> if you are going with traditional export (the one with exp) then you need
> to ensure you have a large enough buffer (think along the lines of largest
> row). Datapump is your best bet from 10g on. Though dblink replication
> won't work on long data, it's easy enough to export only tables containing
> longs to a dump and duplicate the rest with datapump over network link.
>
> hth
>
> Alan.-
>
>
> On Tue, Apr 23, 2013 at 1:13 AM, Raja Subramaniyan <raja.s28_at_gmail.com>wrote:
>
>> Hi,
>> I need to safely transfer databases / tables with LONG RAW coloumns from
>> one machine to another.
>>
>> What parameters have to be used to make exp work with the LONG RAW data
>> type and what are all the steps have to be taken?
>>
>> Thanks
>> Raja
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

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

Received on Tue Apr 23 2013 - 08:09:24 CEST