OraFAQ Forum: Server Utilities » How to load a text file into table?

Home » RDBMS Server » Server Utilities » How to load a text file into table?

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

How to load a text file into table? [message #70188]

Fri, 26 April 2002 16:00

Paul
Messages: 164
Registered: April 1999

Senior Member

I need to load over 1000 text files into one table. any ideas? Thanks!

Report message to a moderator

Re: How to load a text file into table? [message #70590 is a reply to message #70188]

Wed, 03 July 2002 20:15

Nofiyanto
Messages: 1
Registered: July 2002

Junior Member

Hey my Name is Nofiyanto i want to know the steping to load one text file into oracle database.
this is the empale of my cases.
The file name is voip-2002-6-14.txt
This is the empale of record file:
14/06/2002 17:10:47, 127.0.0.1, 23, 5, Jun 14 17:10:47 202.155.34.211 RealSource:"202.155.34.211" 109: .Jun 14 17:12:16.667: %VOIPAAA-5-VOIP_CALL_HISTORY: CallLegType 1, ConnectionId B5D5B9A2 7EB511D6 80A08073 1B86857F, SetupTime .17:10:12.517 WIB Fri Jun 14 2002, PeerAddress 08551007799, PeerSubAddress , DisconnectCause 10 , DisconnectText normal call clearing., ConnectTime .17:10:29.447 WIB Fri Jun 14 2002, DisconnectTime .17:12:16.667 WIB Fri Jun 14 2002, CallOrigin 1, ChargedUnits 0, InfoType 2, TransmitPackets 0, TransmitBytes 0, ReceivePackets 0, ReceiveBytes 0
I just want to take some field from that data like date in(14/06/2002),timein(17:10:29.447),timeout(17:12:16.667)peerAddress(08551007799),sourceAddress(202.155.34.211) please i really need your help.
Thank's very much

Report message to a moderator

Previous Topic:	how to copy table from user to another user
Next Topic:	Export without triggers for Oracle 8.1.6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 07:20:48 CDT 2024