Re: imp - BLOB - reduce imp time

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sat, 18 Jun 2005 21:17:42 +0200
Message-ID: <42b47357$0$314$ba620e4c@news.skynet.be>

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:1118938501.29523.0_at_nnrp-t71-03.news.uk.clara.net...
> 9.2.0.4
> RHEL 3
>
> Hi
>
> We have many tables that contain BLOBS and when it comes to move data from
> production to dev exp/imp is often the best way to do this. during exp i
> set BUFFER to be 1048576 and i also set this during my imp -
>
> The imp takes rather a long time, around 2 hours for 6 gig, as i would
> expect but are there any tips to reduce the amount of time taken to import
> BLOBS ? Import files and datafiles are on different disks and performance
> is very good when importing anything other than BLOBS.
>
> thanks for any tips

Maybe you could run several import scripts in parallel, if your disk subsystem can handle this. Received on Sat Jun 18 2005 - 14:17:42 CDT