Tom wrote:
> 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
Use transportable tablespaces: Not export/import.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jun 16 2005 - 11:45:13 CDT
