Re: Import Export Utility

Check the alert log to see if it has to wait to finish a checkpoint before it switches the log files. If so, maybe your redo log files are too small. I had the same problem, but was resolved by increasing my redo log files from 1 meg to 5 megs.
Also, it all depends on what your exporting (is it a huge file or not). Don't make me define what is huge or not. ;) Satar Naghshineh
SatarNag_at_worldsite

Don Humberson wrote:
>
> Sanjeev,
>
> Check what you are moving and why - often, you can just export/import rows
> and add constraints, indices, etc after the new rows are committed.
>
> Don Humberson
> 'No, I'm no guru, but this may help.' - DBH
>
> Software Administrator wrote:
>
> > Hello Oracle Guru's,
> >
> > My import and export utilitys are taking very long time. Are there any
> > parameters to be set? Please drop a line or two.
> >
> > Thanks in advance
> > Sanjeev
Received on Mon Sep 08 1997 - 00:00:00 CDT