Home » RDBMS Server » Server Utilities » sqlldr (9208)
sqlldr [message #343030] Mon, 25 August 2008 23:46 Go to next message
udara
Messages: 9
Registered: July 2008
Location: COLOMBO
Junior Member
hi all
i need to upload txt file data to oracle. this should be automated process. txt file contents 5000 records at a time and at every 5 minits 3 files generated
i need to add as a one column to oracle

oracle table structrue

CREATE TABLE telco
(
RECORD VARCHAR2(256 BYTE),
FLAG NUMBER
);


txt file formate
Event: "0714226064","4","2008/06/01-16-47-07.00",,,,,,,,,,"0714226064","0773017341",,"1",,,,"11947100003",,,,,,,,,,,,,,,"HW",

Event: "0718936244","4","2008/06/01-16-47-17.00",,,,,,,,,,"0718936244","0715484863",,"1",,,,"11947100003",,,,,,,,,,,,,,,"HW",

plese help me
Thanks
Udara
Re: sqlldr [message #343031 is a reply to message #343030] Mon, 25 August 2008 23:51 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Forgive me, but I do not understand the problem statement; or the desired solution.

[Updated on: Mon, 25 August 2008 23:51] by Moderator

Report message to a moderator

Re: sqlldr [message #343032 is a reply to message #343030] Mon, 25 August 2008 23:54 Go to previous messageGo to next message
udara
Messages: 9
Registered: July 2008
Location: COLOMBO
Junior Member
hi
why did i do wrong!!! by posting problem under utility?? i need solution.. basical how i can uplodate to oracle as one string.in other word as one colum
thanks
Re: sqlldr [message #343040 is a reply to message #343030] Tue, 26 August 2008 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Loader or external table.

Regards
Michel
Re: sqlldr [message #343068 is a reply to message #343040] Tue, 26 August 2008 03:26 Go to previous messageGo to next message
udara
Messages: 9
Registered: July 2008
Location: COLOMBO
Junior Member
yes i know using sqlldr. how to insert records
ex:sqlldr ud/ud@RC_MOBTL control=/u06/xyz.ctl log=/u06/sqlldr_log.log

but my taxt file content spaces between two rows. how to avoid these blank row and insert records to table using SQL LDR

thanks
Re: sqlldr [message #343116 is a reply to message #343068] Tue, 26 August 2008 05:56 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use WHEN clause to ignore empty lines or "where ... is not null" with external table.

Regards
Michel
Previous Topic: segment corruption--how to recover table??
Next Topic: SQL Loader INFILE w/ Date
Goto Forum:
  


Current Time: Tue Dec 06 02:19:29 CST 2016

Total time taken to generate the page: 0.05377 seconds