no, no.... i probably was not clear in my haste and frustration.
simple question...
how do you write the exp/imp statements to maximize performance.
the cryptic hints and examples were not sufficient for me to
extrapolate a method of acompli****ng a fast imp.
i was able to use the suggestions for exp and improve my exp speed.
now my problem is with imp.
IMP'ing the default, OWNER= dump can take a few hours.
what i understood from my readings, and i'm admitting that i may need
to do more reading/studying... but what i understood is this:
execute big table im****ts in parallel and reduce the complexity of the
sequential IMP process.
to accomplish that, i'm assuming you want identify and strip out
commands so that you can execute those big table im****ts at the same
time.
also, it said to perform index creation post data imp.
so, i started ha****ng through it.
built a bunch of exp statements, thinking i could do a call *.bat to
parallelize the exps.
and then on the imp side basically do the same thing.
i got confused, decided it was time to ask for some help.
and, here we are....
i'm guessing the answer may be along the lines of ymmv and each
situation is unique.
i'd like a real world like example; maybe something along the lines
of...
1. execute an imp u/p@[EMAIL PROTECTED]
blah-blah-blah
2. execute 'create index' blah-blah
3. rinse-n-repeat until all indexes created...
fl
|
