Setting up OS authentication
Date: Thu, 21 May 2009 10:38:33 -0700 (PDT)
I'm trying to setup Oracle 10g to use OS authentication but are getting the following errors.
SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-01738: missing IN keyword
Oracle IDs are working fine it's just when I use OS authentication. I tried googling this but the solution is to "Place the keyword IN and lock mode directly after the table name in the LOCK TABLE statement and retry the statement." Not sure where to put it in the test case below.
Below is the simple Oracle test case I used.
Create test table:
create table test (i number, s varchar2(3));
INTO TABLE test
FIELDS TERMINATED BY "|"
1|foo 2|bar 3|bazReceived on Thu May 21 2009 - 12:38:33 CDT