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