Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> IMPORT 20G database ..(SLOW!!!!)

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

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 14 Aug 2001 17:58:18 -0700
Message-ID: <93f65984.0108141658.b2ee062@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 Tue Aug 14 2001 - 19:58:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US