OraFAQ Forum: Server Utilities » SQL*Loader Performance (Multi-file-table Load)

Home » RDBMS Server » Server Utilities » SQL*Loader Performance (Multi-file-table Load)

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

SQL*Loader Performance (Multi-file-table Load) [message #71393]

Sun, 27 October 2002 03:25

Omer
Messages: 19
Registered: July 2002

Junior Member

Is there a way to load data from multiple files (n files n > 10) into multiple tables (m tables, where m > 100) using SQL*Loader? and how can we improve the performance of such process?

Thanks in advance for your help :)

Report message to a moderator

Re: SQL*Loader Performance (Multi-file-table Load) [message #71402 is a reply to message #71393]

Mon, 28 October 2002 05:45

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try soemthing like.

LOAD DATA    
INFILE 'file1.dat'    
INFILE 'file2.dat'    
APPEND 
INTO TABLE table1
 (.............)
INTO TABLE table2
 (.............)

Report message to a moderator

Previous Topic:	Problem with Group by
Next Topic:	"segmentation fault" on RedHat linux7.2 Oracle 8.1.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 03:02:49 CDT 2024