Re: Oracle 10g imp woes

From: Navs <naveen.kanchetti_at_gmail.com>
Date: 27 Jun 2005 08:48:17 -0700
Message-ID: <1119887297.836446.125570@z14g2000cwz.googlegroups.com>

Hi andrew,

i too faced this quite no. of times, the main source of the err. is due to storage clause in object creation. it happens due to setting

compress=y (by default it is 'y' you have explicitly specify
compress=n) during exporting the database.always ensure you use
compress=n in your export command. if you've already created the dump

you can use
the following workaround

pre-create all the objects before you start import. and use ignore=y option during your import

hope this will help you,
Regards
Naveen Received on Mon Jun 27 2005 - 10:48:17 CDT