OraFAQ Forum: Server Utilities » Export Comma Delimited File to Oracle

Home » RDBMS Server » Server Utilities » Export Comma Delimited File to Oracle

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

Export Comma Delimited File to Oracle [message #73345]

Wed, 31 March 2004 02:52

Suroop B
Messages: 2
Registered: March 2004

Junior Member

hi friends,

I am having a problem regarding the export of comma delimited flat files to Oracle database by using the SQL*Loader.Please give me your suggestions/solutions regarding this.

My Table name :Temp
Table Structure:
Name Char
Address Char
State Char
City Char
Zip Char
Country Char
Phone Number

My data in the flat file is (Row wise)
"King","Park Street","CA","California",234444,"US",4234244
"James",Lincoln Street","SA",4535355
"Ronald",Church Avenue","AUS",534533555

Now how I need to export these data into Oracle.In the above 3 records some of the data is missing for some columns and also there is no comma delimited for those columns.Assume that I am having one million records to export into Oracle in n number of files.How can I do this?
If you can give the script or explain me the method it will be more useful for me.

Thanks in Advance

Suroop

Report message to a moderator

Previous Topic:	Do I need to ReIndex after Migration?
Next Topic:	ORA-24314 service handle not initialized

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:15:22 CDT 2024