Hi,
While loading the mulitiple files through sql loader, i was getting below error
SQL*Loader-951: Error calling once/load initialization
ORA-26002: Table T1 has index defined upon it.
Later i used SKIP_INDEX_MAINTENANCE=TRUE to avoid but this have disabled index under my table T1 , is there a way to avoid disabling the indexes i mean to use direct and parallel load
ctl file
LOAD DATA
INFILE '/path/1.dat'
INFILE '/path/2.dat'
BADFILE '/path/1.bad
DISCARDFILE '/path/1.dsc'
INTO TABLE T1
APPEND
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(ID,
date_col);
sqlldr userid=user/pass@db control=/path/test.ctl parallel = true direct = true SKIP_INDEX_MAINTENANCE = TRUE log=/path/.$(date +"%Y%m%d_%H%M%S").log errors=100000