Setting up OS authentication

From: <yeungj16_at_gmail.com>
Date: Thu, 21 May 2009 10:38:33 -0700 (PDT)
Message-ID: <4d1f619c-cb14-41ac-8eda-f1c3f88ccfe2_at_w40g2000yqd.googlegroups.com>



Hi,

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.

Thanks,

Create test table:

create table test (i number, s varchar2(3));

Control file:

OPTIONS (DIRECT=TRUE)
LOAD DATA
INFILE test.dat
APPEND
INTO TABLE test
FIELDS TERMINATED BY "|"
(i, s)

Data file:

1|foo
2|bar
3|baz
Received on Thu May 21 2009 - 12:38:33 CDT

Original text of this message