| SQL loader error while using parallel in direct path [message #646262] |
Wed, 23 December 2015 07:50  |
 |
rohit_shinez
Messages: 139
Registered: January 2015
|
Senior Member |
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
