how to do exp imp faster
Posted on 2004-04-28
I have a default oracle install 9.2, on solaris 9, I am importing about 1.8GB of data from a 816 database that was on solaris 2.6. I have the export done as one file. My load with imp is going slower than I would like. Does anybody have tuning recommendations, or a better way to do a export/imp I am switching user id and charset. The command I am using are
exp system/manager log=prodexp.log owner=lawprod compress=y
imp system/manager file=/tmp/expdat.dmp fromuser=lawprod touser=law7 indexes=n log=/tmp/prod.log ignore=y
I am sure there is a faster way, sqlloader, tunning of the sga, possible spliting the export with named pipes. I have read many snippet out on the web about these various things, but I haven't had a lot of luck implementing them.
The data and Indexes are in seperate tablespaces that is why I have indexes=n.
I don't have toad or oms so I am stuck with command line.
Thanks for any help in advance, Oracle newby