OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sqlldr (9208)

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

sqlldr [message #343030]

Mon, 25 August 2008 23:46

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

Report message to a moderator

Re: sqlldr [message #343031 is a reply to message #343030]

Mon, 25 August 2008 23:51

BlackSwan
Messages: 26766
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

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

Report message to a moderator

Re: sqlldr [message #343040 is a reply to message #343030]

Tue, 26 August 2008 00:50

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Loader or external table.

Regards
Michel

Report message to a moderator

Re: sqlldr [message #343068 is a reply to message #343040]

Tue, 26 August 2008 03:26

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

Report message to a moderator

Re: sqlldr [message #343116 is a reply to message #343068]

Tue, 26 August 2008 05:56

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use WHEN clause to ignore empty lines or "where ... is not null" with external table.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:17:27 CST 2024