sqlldr详细用法（Sqlldr detailed usage）.docVIP

sqlldr详细用法（Sqlldr detailed usage） Sqlldr detailed usage 2006-06-29 18:40:16 Small and medium-sized Sqlldr userid=lgone/tiger control=a.ctl LOAD DATA INFILE /t.datfile to import INFILE / /tt.date/ / importing multiple files * / / INFILE / / to import the contents of the control file below BEGINDATA is behind the import content INTO TABLE table_name / / specified loading table BADFILEc:\bad.txt/ / bad file specified address The following are the 4 ************* loading table way APPEND / / the original data table in the back / / INSERT / / loading empty table if the original table data sqlloader will stop the default value / / REPLACE / / the original table original data will be deleted / / TRUNCATE / / replace specifies the content and the same will delete the existing data with the truncate statement ************* specified in table TERMINATED can start in the internal field can also be part of the table FIELDS, TERMINATED, BY, OPTIONALLY, ENCLOSED, BY The loading / / data: 10, LG, LG , LG, lg The results in table: 10 / / LG LG LG, LG BY X09/ / TERMINATED / /09 sixteen in hexadecimal format TERMINATED BY / / WRITESPACE / / loading this data: 10 LG LG TRAILING NULLCOLS ************* field table not allow null values corresponding to the Below is a table in the field ************* ( Col_1, col_2, col_filler value is not this column FILLER / / FILLER keyword is loaded Such as: LG, LG, not LG LG ) When FIELDS TERMINATED BY / / no statement , (/ / Col_1 [interger external] TERMINATED BY /, Col_2 / [date dd-mon-yyy TERMINATED BY , [char] TERMINATED / / col_3 BY ENCLOSED BYlg OPTIONALLY . / / a) When FIELDS TERMINATED BY / / no statement , location to the loading of data field (/ / Col_1 / position (1:2), Col_2 / position (3:10), / / col_3 position (* 16), / / this field at the beginning of the end position of the front of a field Col_4 / position (1:16), Col_5 / position (3:10) char (8) / / type of the specified field / / a) BEGINDATA / INFILE * corresponding began to im