Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> IMPORT 20G database ..(SLOW!!!!)
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 Tue Aug 14 2001 - 19:58:18 CDT