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

JK,

   You don't give a database version number which makes it difficult to know if this advice is relevant or not, BUT, it may be that you need to specify a fairly large buffer parameter (eg 100000000). I've experienced problems of this sort before with tables that contained LONG columns. It might also be interesting to know what OS you're on, what sort of a machine you're running the job on and if the import hangs at a certain point or is just generally slow. If all else fails your suggestion of performing the export table by table might be a good one. I'd try and get some grasp of the actual problem first though,

Regards,

Mick Rice.

 jkyf0131_at_hotmail.com (JK Yao) 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). &#60966;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 - 04:08:11 CDT