-
trying to import to a table in the database but the import contains 42 million rows and it is taking 60 hours to complete! it is 4gb.
what can I do to rectify this or speed things up
here is the script I ran to do the import
mknod /tmp/imp_pipe_ccd p
uncompress < expabc.dmp.Z > /tmp/imp_pipe_ccd &
imp file=/tmp/imp_pipe_ccd userid= fromuser=abc touser=abc log=imp_abc.log commit=y ignore=y
indexes=N buffer=64000
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|