URGENT : Problem with migrating from 8.1.6.0.0 to 9.0.1.0.0

Hi all,

       I have a problem with sqlloader when migrating from 8.1.6 to 9.0.1 . I have a sqlloader script which populates a table . "User A" owns table EMP and OPS$ logs in from sqlldr and truncates the table and loads the new datafile .

        In Oracle 8 OPS$ORACLE has only connect and resource roles associated with it and when I load it with direct=true it loads it all fine .
The control file looks like this
load data
replace
into table EMP
when db_orgin <> X'1A'
fields terminated by '|' --OPTIONALLY ENCLOSED BY '"' trailing nullcols
(

  ename,
  department,
  salary
)

          sqlldr userid='OPS$ORACLE'/externally control=test.ctl direct=true log=test.log bad=test.bad data=test.data

Cut to Oracle 9 I gave OPS$ORACLE connect,resource as well as DBA privileges (out of frustration ) and try to run the same command but it give me the following error .(ALTHOUGH IT TRUNCATES THE TABLE ,its "replace" in control file) .
SQL*Loader: Release 9.0.1.0.0 - Production on Tue Jan 28 18:08:57 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-01740: missing double quote in identifier

Try loading it with direct=FALSE and IT LOADS FINE , which means that table privileges are all good . There are no indexes on the table. Direct Path works for "USERA" the owner of the table. Please all gurus out there help me in knowing if I am doing anything wrong .
Thanks in Advance,
Rakesh. Received on Tue Jan 28 2003 - 18:22:42 CST