Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT 20G database ..(SLOW!!!!)
Just curious, anyone has experience with COMMIT parameter of the import
utilities.
If commit=y, Oracle keeps on flush the redo log buffer which slow down the
import; If I set commit=n Oracle requires bigger rollback segments which
PROBABLY takes a lot of time too.
any suggestions are welcomed.
Wayne
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3B7D780D.7A03_at_yahoo.com...
> JK Yao wrote:
> >
> > dear all,
> >
> > I imported the database and spend more than 20 hours and finish not
> > even half way (7G). How to solve it?
> > 1. Is it normal that impoting got hang when import big table (millions
> > rows)?
> > 2. Should I import those big tables one by one first and then do full
> > import. Will this help?
> >
> > Our database is about 20G.
> > I used following parameters:
> >
> > full=y
> > commit=y
> > indexes=n
> > log=A.log
> >
> > Need help!
> > Thanks.
> >
> > regards,
> > JK
>
> Take a look at the tip on my site (see below)
>
> hth
> connor
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Fri Aug 17 2001 - 19:08:54 CDT