SQL*LOADER
Hi All,
We are getting below error in 11.2.0.3 while loading some data using sqlloader. Anyone has some idea how to fix this issue in 11.2.0.3?
same sqlloader is working fine in 10.2.0.5
OPTIONS (SKIP=1)
LOAD DATA
TRUNCATE
INTO TABLE user.table
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
SQL*LOADER-926:oci error while executing delete/truncate (due to replace/truncate keyword) for table.
ORA-01031: insufficient privileges
Thanks,
Man
0