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

hi,

I use Oracle8i and IMPORT8.1.6
OS: Solaris 5.7
Server Sun E3000. 3 250MHz CPUs with 2GB memory. Database size:20GB.

I have following questions too:

1. The importing is getting slower. At first two hours, the import is fast but later in some specific table it got slow and never turn fast. Any parameter I should set to get the process faster? What number should I put in buffer? Does that help to speed up the import?
2. I have an idea. How to import user without schema? So, I can import large tables one by one. After I imported those large tables (more than 500K rows), and then I can do full import. Does this help???
3. I already set index=n and commit=y. So, any parameter to speed up the process.

I already set following parameters:
full=y
commit=y
indexes=n
log=A.log
buffer=1024000

please help.
thanks in advance,
JK

mickrice_at_techie.com (Mick Rice) wrote in message news:<645b6e08.0108150108.46a78026_at_posting.google.com>...
> 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 - 22:26:34 CDT