Tuesday, 12 April 2016

Data Mover Scripts

/* need to run in the EVironment where data is available */
SET LOG C:\TEMP\EXPORT.LOG;
SET OUTPUT C:\TEMP\EXPORT.DAT;
EXPORT  TABLENAME   ;




/* need to run in the EVironment where data is not available */
SET INPUT C:\TEMP\EXPORT.DAT;
IMPORT * ;
UPDATE_DuPS / IGNORE_DUPS;

No comments:

Post a Comment