ALTER TABLE tab1 NOLOGGING
only works for direct load, i.e not for copy or import
you either drop or keep index but you cannot set it to unusable, copy wont work
This is the best method....rather than DB link or imp/exp.
Originally posted by pando
spool to flat file
load with sql loader, direct path if possible, if not split the flat file into 5 or 6 files and load with sql loader
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
when export lasts 1 hour and import lasts days the n the index-build should be the problem.
So increase your sort_area_size ( under 9i ) for example to 256M or more so that data can more sorted in memory then on temp-tablespace.
with 9iR2 increase the PGA_AGGREGATE_TARGET to 256M or more
Use this parameter to
determine the optimal size of each work area allocated in AUTO mode (in other
words, when WORKAREA_SIZE_POLICY is set to AUTO.
* Try to seperate the index-build and create them with nologging
Another problem of lacking writes could be
* size of log_buffer
* location, number and size of logfiles
Click Here to Expand Forum to Full Width