Re: IMPort Utility

use COMMIT=Y option with the imp command ex imp uid/pwd file=xyz commit=y indexes=N) Also, turn off the index creation process using indexes=N with the imp command
Once the data is successfully imported,
you can create the indexes
It seems that the import is filling your log files very quickly so that it can not switch the logfile
try creating more log groups with bigger filesize these can be dropped later if you wish

HTH Madhu Cherukuri

Dan DiNardo wrote in message <6r6q5o$b5q$1_at_news-1.news.gte.net>...
>Geoff,
>Are you saying that it must be set to NO to successfully import the file?
>What is the SVRMGRL or SQLPLUS command to change the setting?
>
>Pardon my ignorance, I'm not a DBA; only one recently shouldered with
>the responsibility.
>
>Regards,
>Dan
>
>GHouck <hksys_at_teleport.com> wrote in article
><35D6610F.6E43_at_teleport.com>...
>> Dan,
>>
>> Have you specified the COMMIT=Y option? A book I have says that
>> there is NO WAY to import a large dump file without this option
>> being set, regardless of your other settings.
>>
>> Yours,
>>
>> Geoff Houck
>> systems hk
>> hksys_at_teleport.com
>> http://www.teleport.com/~hksys
>>
Received on Sun Aug 16 1998 - 21:41:50 CEST