Export data

Create SQL script for index creation

This script will be used later to create indexes. Creating indexes is faster then import. Example of UNIX command:

TBD

Drop tables

Drop tables which will be imported. You can find these tables in export log:

Example of SQL command which drops table:

drop table FAF_DWH_HIS.PLAN_TABLE;

Enlarge parameter sort_area_size

After data are imported tables are sorted and this consumes much time if this parameter is small. Therefore check parameter sort_area_size which should be at least 1048576. Example SQL command to check sort_area_size parameter:

show parameter sort_area_size;

Example SQL command to set new value:

alter database set sort_area_size=1048576 deferred;

Create import parameters files

You should create several parameters files as each file can be used in parallel import session. Using more sessions increases the import performance (up to 8 import sessions is fine). In each import file define different tables all together with cca same number of rows. Example of files used to import FAF_DWH_HIS schema: