OraFAQ Forum: Server Utilities » SQL Loader .ctl script

Home » RDBMS Server » Server Utilities » SQL Loader .ctl script (ORACLE 10g Windows 2003)

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

SQL Loader .ctl script [message #417653]

Mon, 10 August 2009 15:59

san123456
Messages: 1
Registered: July 2009
Location: Fort Lee

Junior Member

Hi,

I really appreciate if anyone help me out in this.

My input(*.txt) file is as below

XXXX transit 14707426812 14774170324 80305 3 12 10 MSC1R12E35I06AF GRIO XXXX12
XXXX Transit 1193700910764 14775159967 80305 7 12 6 MSC1R12E35I06AF GRIO XXXX12
XXXX transit 1193700973711 14774813616 80305 12 18 6 MSC1R12E35I06AF GRIO XXXX12
XXXX transit 1193700215157 14774038654 80305 44 47 4 MSC1R12E35I06AF GRIO XXXX12
i wrote the control file as below

Load data

Append
into table MTN_032008

(
Carrier(A), CallType(B), CallingPartyNo(C), CalledPartyNo(D),
DateStartCharge Date 'YMMDD'(E), TimestartCharge(F), TimestopCharge(G), ChargableDuration(H),ExchangeID(I), OutgoingRoute(J), IncommingRoute(K))

Please help me.

San

Report message to a moderator