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

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..."