Database Utilities (MOSC)

MOSC Banner

SQL*LOADER

edited Apr 4, 2013 1:11AM in Database Utilities (MOSC) 4 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center