Home » RDBMS Server » Server Administration » How to load multiple datafile into one table?
How to load multiple datafile into one table? [message #63573] Mon, 18 October 2004 02:13 Go to next message
LEE SHIN YOUNG
Messages: 4
Registered: October 2004
Junior Member
hi! I want to load two datafile into one table by control file.

for example, TPD71M$AUD.prn is 2 rows and

TPD72M$AUD.prn is 3 rows. then tpd71m$audTemp table is 5 rows. So next control file is it possible?

Please help me...

              

LOAD DATA
INFILE 'E:TPD71M$AUD.prn'
INFILE 'E:TPD72M$AUD.prn'

INTO TABLE tpd71m$audTemp
(Pj_Cd POSITION(01:10) CHAR,
Curr_Sts POSITION(12:13) CHAR,
Pj_Chrct POSITION(20:21) CHAR)

Report message to a moderator

Re: How to load multiple datafile into one table? [message #63609 is a reply to message #63573] Wed, 20 October 2004 05:20 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

"To load data from multiple datafiles in one SQL*Loader run, use an INFILE statement for each datafile." - Oracle9i Database Utilities Guide.

Best regards.

Frank

Report message to a moderator

Previous Topic: upgrading to 9i
Next Topic: Import data from dat file to table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:27:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.