Oracle uses sqlldr (with sequence) to import data, sqlldrsequence

Oracle uses sqlldr (with sequence) to import data, sqlldrsequence

Command:

Sqlldr userid = [USERNAME]/[PASSWORD] @ [DATABASE] control = [FILEPATH]

Username

Password

Database instance

Filepath: physical path of the ctl File

-----------------------------------------------------------------------

File:

Load datainfile * append into table [TABLENAME] fields terminated by "," trailing nullcols ([ID] sequence (1, 1), [COL1], [COL2], [COL3], [COL4], [COL5], [COL6]) Begindatax, xx, xxx, xxxx, xxxxx, xxxxxxa, aa, aaa, aaaa, aaaaa, aaaaaa

Tablename table name

Id Primary Key

Col1, 2, 3, 4, 5, 6 Field Names