OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL Loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader [message #72703]

Fri, 26 September 2003 10:09

sheela
Messages: 66
Registered: March 2002

Member

> Hi,
>
> I would like to use the SQLLDR, but I am having a problem because my password has a "," in it. Is this always a problem, or is there a way to get around it?
>
> Thanks.
> Sheela.

Report message to a moderator

Re: SQL Loader [message #72704 is a reply to message #72703]

Fri, 26 September 2003 11:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

sure!
escape the comma ','

test@mutation_mutation > select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

test@mutation_mutation > truncate table dept;

Table truncated.

test@mutation_mutation > !
$  sqlldr userid=test/"tes,t" control=dept.ctl

SQL*Loader: Release 9.2.0.1.0 - Production on Fri Sep 26 12:27:28 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 4
$ exit

test@mutation_mutation >  select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

test@mutation_mutation >

Report message to a moderator

Re: SQL Loader [message #72705 is a reply to message #72703]

Fri, 26 September 2003 11:23

Thiru
Messages: 1089
Registered: May 2002

Senior Member

or consider changing the password. The comma, is bound to give you problem one way or the other sooner or later .

Thiru

Report message to a moderator

Re: SQL Loader [message #72706 is a reply to message #72704]

Fri, 26 September 2003 11:29

sheela
Messages: 66
Registered: March 2002

Member

Hello,

It is *hard* to make out your suggestion.
Are you suggesting double quotes around the password with the comma?

Thanks.
Sheela.

Report message to a moderator

Re: SQL Loader [message #72707 is a reply to message #72704]

Fri, 26 September 2003 11:33

sheela
Messages: 66
Registered: March 2002

Member

Hello,

Sheela, here, again.

Or, are you suggesting double quotes, and then, the rest of your password before the comma, and then a backslash followed by your comma, again ending in the double quote?

Thanks.
Sheela.

Report message to a moderator

Re: SQL Loader [message #72708 is a reply to message #72707]

Fri, 26 September 2003 12:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yes.
enclose the password with double quotes.
and esscape the ',' with the ''.
is the usernam=test
       password=tes,t
in command line use
sqlldr userid=test/"tes,t"

Report message to a moderator

Previous Topic:	How to import tab seperated file
Next Topic:	help!i am using exp and get error infomation"EXP-00008: ORACLE error 6552 encountered"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 12:46:03 CDT 2024