Home » RDBMS Server » Server Utilities » problem with sql loader
problem with sql loader [message #185324] Tue, 01 August 2006 04:21 Go to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi Naveen,

i am working Oracle 8.7.0 version and my database is in singapore and i usally connect my server with help of TOAD for running the csv files . And when we moved our oracle database to new server i cant able to use the sql loader now.it all ways gives me error



SQL*Loader: Release 9.0.1.1.1 - Production on Tue Aug 1 14:54:59 2006

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

SQL*Loader-101: Invalid argument for username/password




SQL*Loader: Release 9.0.1.1.1 - Production on Tue Aug 1 14:54:59 2006

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


SQL*Loader-101:
Invalid argument for username/password



plz help to recover from this issuse.....



AND PLZ TELL ME HOW TO CHANGE


Errors allowed: 50 TO Errors allowed: 100000 IN TOAD WHILE USING SQL LOADER



Thanks in Advance
Naveen
  • Attachment: BIN_MAS.log
    (Size: 8.61KB, Downloaded 342 times)

[Updated on: Tue, 01 August 2006 04:32]

Report message to a moderator

Re: problem with sql loader [message #185343 is a reply to message #185324] Tue, 01 August 2006 05:10 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"SQL*Loader-101: Invalid argument for username/password" suggests that your command line isn't correct. Could you post it here?

LOG file in the attachment shows that loading session succeeded, but failed to load any records as all of them violated unique constraint.
Re: problem with sql loader [message #185356 is a reply to message #185343] Tue, 01 August 2006 05:41 Go to previous messageGo to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

hi,

Thanks for ur immediate response .. this one of my old log file... but wen i am trying to insert it it is not allowing to run and it gives me the same error.. and i cant identify error it happens

1. whether it is granting privillege (but the user has DBA privillege)

2.whether it is in N/W
3.

SQL*Loader-101: Invalid argument for username/password"

and also plz tell me how to change this parameter in toad

Errors allowed: 50
TO
Errors allowed: 10000

IN TOAD WHILE USING SQL LOADER


Thanks in advance

Naveen

Re: problem with sql loader [message #185367 is a reply to message #185356] Tue, 01 August 2006 06:48 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, but I never used TOAD and SQL*Loader together; when I need to, I write control file and invoke Loader from the command prompt; could you try to do so too?

I *think* that TOAD allows you to save control file on the disk. Take it and use it in a statement like this:

> sqlldr userid=scott/tiger@ora8 control=my_load.ctl log=my_load.log

Perhaps it'll work correctly.
Re: problem with sql loader [message #185386 is a reply to message #185356] Tue, 01 August 2006 08:40 Go to previous messageGo to next message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
Hi -

Could you please provide me with few more information:
1). Your parameter file generated in TOAD.
2). Your log file.
3). The format of your data you are loading, I mean how it is organized in the external format.

Thanks!
Re: problem with sql loader [message #185415 is a reply to message #185324] Tue, 01 August 2006 11:31 Go to previous messageGo to next message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
If you are using toad's SQLLDR to upload file then you should be connected to a session which has permissions to write on table you want to. Toad will create the control file which will be used for loading. Username and password argument doesnot come into pic.
Re: problem with sql loader [message #185532 is a reply to message #185415] Wed, 02 August 2006 03:12 Go to previous messageGo to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi manish,

i dont want bulid the control file using Toad, and i have prepared my control file using table structure, the thing is wen i use this option it gives me error that

SQL*Loader-101: Invalid argument for username/password

i have also attached the sanpshoy all the proceess

plz give solution for this issue

tell me how change this parameter in toad
Errors allowed: 50
TO
Errors allowed: 10000


IN TOAD WHILE USING SQL LOADER


Regards

Naveen
Re: problem with sql loader [message #185538 is a reply to message #185532] Wed, 02 August 2006 03:58 Go to previous messageGo to next message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
Hi Naveen,

Can you provide me with the contents of control file you using?

Thanks,
Rama.
Re: problem with sql loader [message #185542 is a reply to message #185538] Wed, 02 August 2006 04:17 Go to previous messageGo to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi,

Plz see the attachment of the control file


Regards

Naveen
Re: problem with sql loader [message #185547 is a reply to message #185542] Wed, 02 August 2006 05:15 Go to previous messageGo to next message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
Naveen,

I just wonder what could be the issue. I tried creating a test table with two columns eno, name. Created a control file on my own and used it in SQL*LOADER of TOAD and it went fine. There wasn't any problem with the load at all.

I tried the same with different schema after granting privileges as well its working good without any flaw.

I just can't understand what's the issue. Can you try load without using TOAD?

Thanks!
Re: problem with sql loader [message #185552 is a reply to message #185547] Wed, 02 August 2006 05:27 Go to previous message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi,

yes i can do it without using Toad. but with help of the Toad i can't able to do that

Regards
Naveen
Previous Topic: DB Refresh- IMPORT
Next Topic: Date format in control file
Goto Forum:
  


Current Time: Fri Dec 02 16:25:36 CST 2016

Total time taken to generate the page: 0.28568 seconds