Re: Copying table from one database to another db which have long raw column & huge data
- From: Raja Subramaniyan <raja.s28@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Tue, 23 Apr 2013 11:39:24 +0530
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@xxxxxxxxx>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@xxxxxxxxx>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
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
