How to import data from text and XML file to oracle database table?

[year2000]

Hi,

I am facing a problem. I want to load data from text file (comma delimited) to oracle database table. I tried using SQL* loader, which requires a control file. I created a control file for the same using TOAD (SQL* Loader wizard), but to my dismay, after execution it shows an error [User/Password error].
My flat file data somewhat looks like this ---
[I am giving an example of first line of text file]
----------------------------------------------
abd,aaaaa,dshj,fg32hgi3,3232bhj
----------------------------------------------
My database column data type is VARCHAR2 (50).

Can anybody help me, in importing this text file comma delimited record to a database table of given specification?
Also how will I import similar data from XML file to database table? Kindly tell me the steps to do this using TOAD.

Thanks

 

[sem]

Are you sure you passed correct username/password?

Regards, Dima

 

[year2000]

Yes becoz when you start TOAD, it always asks for username and password. Without proper authentication, you can not use its features, then obviously I was connected to database. Moreover in TOAD SQL* Loader wizard, there is no option for specifying username /password.

The exact message I am getting is as follows:

SQL* Loader-101- Invalid argurment for username/password

If there is any other way then pls let me know.
Regards

 

[sem]

I don't know how it works from TOAD, by the first positional parameter should be userid. Try to check (and change) the real command, issued by TOAD or launch sql*loader from command prompt.


Regards, Dima