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

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 23 Apr 2013 09:22:52 -0300
Message-ID: <CAJ2dSGTghH9VpEugDQTDP-GP8jhNqjbn1OdocmZk7n71mO4xfw_at_mail.gmail.com>

Well, I just told you. the restrictions are the buffer size in traditional exp, and the fact that you can't use a network link with datapump. Cheers

Alan.-

On Tue, Apr 23, 2013 at 3:09 AM, Raja Subramaniyan <raja.s28_at_gmail.com>wrote:

> 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 - 14:22:52 CEST