Oracle Sqlldr (i)

--Create TableCreate TableDEPT2 (DEPTNO Number(2) not NULL, DnameVARCHAR2( -), LOCVARCHAR2( -));Alter TableDEPT2Add constraintDept_pkPrimary Key(DEPTNO); ------Demo.ctlLOADDatainfile*---* indicates that the data is in the control file into TABLEDEPT2INSERT---The default load modeFields TERMINATED by ','---separators(DEPTNO, dname, LOC)---The default type is char (255) BegindataTen, Sales,virginia -, Accounting,virginia -, Consulting,virginia +, Finance,virginiasqlldr userid=Scott/Dcjet Control=/Home/Oracle/Demo.ctlLog=/Home/Oracle/Demo.LogBad=/Home/Oracle/Demo.bad Discard=/Home/Oracle/Demodiscard.LogDirect=True Parallel=true--Direct and parallel do not have any problems when they are true alone--when direct and parallel are true at the same time, the current control file must be loaded as append and cannot have an index

Oracle Sqlldr (i)