Home » RDBMS Server » Server Utilities » SQL*Loader help with control file
SQL*Loader help with control file [message #74339] Thu, 18 November 2004 05:43 Go to next message
Horyna
Messages: 2
Registered: November 2004
Junior Member
Hello,
i need to make a control file for this :
1, every table is in a separate file
2, every file has a header with atributs name
e.g. :
file table1:
"atribut1";"atribut2";"atribut3"
0;"text";1.1.2005
1;"text2";2.1.2005

file table2:
"atribut1";"atribut2";...
0;"text";...
1;"text2";...

can me somebody help ? Thanks

Report message to a moderator

Re: SQL*Loader help with control file [message #74725 is a reply to message #74339] Tue, 08 February 2005 08:06 Go to previous message
thumsup9
Messages: 4
Registered: February 2005
Junior Member
load data
infile 'sample.txt'
replace into table sample
fields terminated by ";"
optionally enclosed by '"'
trailing nullcols
(
field1,
field2,
field3
)

Report message to a moderator

Previous Topic: sql loader-925
Next Topic: exp & imp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 19:45:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.