How to speed up legacy Oracle import (using utility imp)
- Article Type: General
- Product: Aleph
- Product Version: 18.01, 20, 21, 22, 23
Description:
How to speed up legacy Oracle import (using utility imp)
Resolution:
1. Modify the parameters COMMIT und BUFFER in line 27 of the script $aleph_proc/oracle_imp_current_lib_a as follows:
from:
aleph_imp FILE=$TMPDIR/imp_pipe.$$ FULL=Y INDEXES=N IGNORE=Y COMMIT=Y BUFFER=5120000
to:
aleph_imp FILE=$TMPDIR/imp_pipe.$$ FULL=Y INDEXES=N IGNORE=Y COMMIT=N BUFFER=51200000
2. Start the import by executing the script $aleph_proc/oracle_imp_aleph_libs.
from:
aleph_imp FILE=$TMPDIR/imp_pipe.$$ FULL=Y INDEXES=N IGNORE=Y COMMIT=Y BUFFER=5120000
to:
aleph_imp FILE=$TMPDIR/imp_pipe.$$ FULL=Y INDEXES=N IGNORE=Y COMMIT=N BUFFER=51200000
2. Start the import by executing the script $aleph_proc/oracle_imp_aleph_libs.
- Article last edited: 10/8/2013