# SQL Loader Configuration Parameters # Old Configuration Name,New Configuration Name,data type, # INSTALLEDMODULE/PHYSICALSTAGECOMPONENTPROPERTY/MAPPINGPHYSICALPROPERTY/PHYSICALMAPPINGSTEPPROPERTY 8i.LOADERMODELS.NAME,NO MATCH,null,null,null 8i.LOADERMODELS.DEPLOYABLE,8i.MAPPINGS.DEPLOYABLE,BOOLEAN,MAPPINGPHYSICALPROPERTY,0 8i.LOADERMODELS.DATAFILE,8i.MAPPINGS.SQLLOADERSTEP.DATAFILE.IDENTIFICATION.DATAFILENAME,STRING,PHYSICALMAPPINGSTEPPROPERTY,1 8i.LOADERMODELS.DIRECTMODE,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.LOADMODEDIRECT,BOOLEAN,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.ERRORS,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.ERRORS,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.BINDSIZE,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.BINDSIZE,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.COMMITARRAY,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.COMMITROWS,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.PURGEGROUP,NO MATCH,null,null,null 8i.LOADERMODELS.OEMJOBNAME,8i.ORACLE8.1.OEMJOBNAME,STRING,INSTALLEDMODULE,0 8i.LOADERMODELS.READBUFFERS,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.READBUFFERS,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.LOAD,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.LOAD,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.SKIP,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.SKIP,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.RECOVERABLE,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.RECOVERABLE,BOOLEAN,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.REENABLE,8i.MAPPING.ENTITY.REENABLECONSTRAINTS,BOOLEAN,PHYSICALSTAGECOMPONENTPROPERTY,0 8i.LOADERMODELS.EXCEPTIONS,8i.MAPPING.TABLE.EXCEPTIONS,STRING,PHYSICALSTAGECOMPONENTPROPERTY,0 8i.LOADERMODELS.SORTEDINDEXES,8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES,STRING,PHYSICALSTAGECOMPONENTPROPERTY,0 8i.LOADERMODELS.LOADMETHOD,NO MATCH,null,null,null 8i.LOADERMODELS.PRESERVEBLANKS,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.PRESERVEBLANKS,BOOLEAN,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.CHARACTERSET,8i.MAPPINGS.SQLLOADERSTEP.SQLLOADERPARAMS.CHARACTERSET,STRING,PHYSICALMAPPINGSTEPPROPERTY,0 8i.LOADERMODELS.RECORDTERMINATOR,FILE.PARAMETERS.RECORDDELIMITER,STRING,MAPPINGSTAGECOMPONENTPROPERTY,0 8i.LOADERMODELS.FIELDTERMINATOR,FILE.PARAMETERS.TERMINATOR,STRING,MAPPINGSTAGECOMPONENTPROPERTY,0 8i.LOADERMODELS.FIELDLEFTENCLOSURE,FILE.PARAMETERS.ENCLOSURE,STRING,MAPPINGSTAGECOMPONENTPROPERTY,0 8i.LOADERMODELS.FIELDRIGHTENCLOSURE,FILE.PARAMETERS.ENCLOSURE,STRING,MAPPINGSTAGECOMPONENTPROPERTY,0 # PL/SQL Configuration Parameters 8i.MODELPACKAGES.IDENTIFICATION,NO MATCH,null,null,null 8i.MODELPACKAGES.NAME,NO MATCH,null,null,null 8i.MODELPACKAGES.DEPLOYABLE,8i.MAPPINGS.DEPLOYABLE,BOOLEAN,MAPPINGPHYSICALPROPERTY,0 8i.MODELPACKAGES.PURGEGROUP,8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTPURGEGROUP,STRING,PHYSICALMAPPINGSTEPPROPERTY,0 8i.MODELPACKAGES.RTPARAMETERS,NO MATCH,null,null,null 8i.MODELPACKAGES.MAXERRORS,8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTMAXERRORS,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.MODELPACKAGES.COMMITFREQUENCY,8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTCOMMITFREQ,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.MODELPACKAGES.BYPASSBATCH,NO MATCH,null,null,null 8i.MODELPACKAGES.OEMJOBNAME,8i.ORACLE8.1.OEMJOBNAME,STRING,INSTALLEDMODULE,0 8i.MODELPACKAGES.APPEND,NO MATCH,null,null,null 8i.MODELPACKAGES.PARALLEL,NO MATCH,null,null,null 8i.MODELPACKAGES.BULKSIZE,8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTBULKSIZE,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 8i.MODELPACKAGES.ESTIMATEPCT,8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTANALYSISPERCENTAGE,INTEGER,PHYSICALMAPPINGSTEPPROPERTY,0 # Pure Integrate Parameters 8i.PUREINTEGRATE.EXECUTABLE,8i.MAPPINGS.PUREINTEGRATESTEP.PUREINTEGRATEPARAMS.PI_EXECLOCATION,STRING,PHYSICALMAPPINGSTEPPROPERTY,0 8i.PUREINTEGRATE.PARAMETER,8i.MAPPINGS.PUREINTEGRATESTEP.PUREINTEGRATEPARAMS.PI_CMDLINEPARAMS,STRING,PHYSICALMAPPINGSTEPPROPERTY,0 # Pure Extract Parameters 8i.PUREEXTRACT.EXECUTABLE,8i.MAPPINGS.PUREEXTRACTSTEP.PUREEXTRACTPARAMS.PE_EXECLOCATION,STRING,PHYSICALMAPPINGSTEPPROPERTY,0