Re: IMPORT 20G database ..(SLOW!!!!)

From: Keith Boulton <kboulton_at_ntlunspam-world.com>
Date: Wed, 15 Aug 2001 11:44:17 +0100
Message-ID: <7ise7.32735$zs.314281@news11-gui.server.ntli.net>

How big are your redo logs? If they are too small (ie the default size), your import could be held up by log switches and checkpoints. There would be messages about checkpoint not complete in your alert log.

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0108141658.b2ee062_at_posting.google.com...
> 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
Received on Wed Aug 15 2001 - 05:44:17 CDT