Re: SQL Loader logon

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 8 Oct 2001 19:07:44 +0200
Message-ID: <ts3noq4eb7j643@news.demon.nl>

"dsmcd" <dsmcd_at_uswestmail.net> wrote in message news:6Ykw7.63$MO6.127965_at_news.uswest.net...
> Hello.
>
> I am a newbie to Oracle and am having trouble using
> sql loader.
>
> I've created the table "main" and have a user "pos".
> The table is in the pos tablespace. I've a comma
> delimited file dat file and a control file. All look fine.
>
> On the server at the command prompt I've tried
> sqlldr userid=pos/pos
> control = c:\main.ctl
>
> I get invalid username/password
>
> same withsqlldr userid=pos/pos_at_servicename
>
> Can someone point this newbie in right direction?
>
> Thx,
> D.
>
>
>

I assume you get ORA-1017, so just
use the correct username/password combination.

Regards
Sybrand Bakker,
Senior Oracle DBA Received on Mon Oct 08 2001 - 12:07:44 CDT