| problem with sql loader [message #185324] |
Tue, 01 August 2006 04:21  |
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 1677 times)
[Updated on: Tue, 01 August 2006 04:32] Report message to a moderator |
|
|
|
|
|
| Re: problem with sql loader [message #185356 is a reply to message #185343] |
Tue, 01 August 2006 05:41  |
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 #185386 is a reply to message #185356] |
Tue, 01 August 2006 08:40 |
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 |
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 |
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 #185547 is a reply to message #185542] |
Wed, 02 August 2006 05:15 |
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!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
