Data Mover Script Templates

Export Record data to File

SET OUTPUT C:\TEMP\PROG_PLN_DATA.dat
EXPORT PS_ACAD_PROG_TBL;
EXPORT PS_ACAD_PLAN_TBL;

Import Record data from File to System

SET IGNORE_DUPS;
SET INPUT C:\TEMP\PROG_PLN_DATA.dat
IMPORT PS_ACAD_PROG_TBL;
IMPORT PS_ACAD_PLAN_TBL;

‘IGNORE_DUPS’ command will ignore the duplicate rows with the same key structure, but it will not check if there is any data change in non key fields.

OR

SET INPUT C:\TEMP\PROG_PLN_DATA.dat
REPLACE_DATA PS_ACAD_PROG_TBL;
REPLACE_DATA PS_ACAD_PLAN_TBL;


‘REPLACE_DATA’ (without ‘IGNORE_DUPS) command will delete the existing data and re-insert the newly available data in the table .



OR

SET INPUT C:\TEMP\PROG_PLN_DATA.dat
REPLACE_ALL PS_ACAD_PROG_TBL;
REPLACE_ALL PS_ACAD_PLAN_TBL;


‘REPLACE_ALL’ (without ‘IGNORE_DUPS) command will drop the table / indexes and then recreate the table and insert  the newly available data in the table .