Home » RDBMS Server » Server Utilities » SQL LOADER for multiple table
SQL LOADER for multiple table [message #394645] Sun, 29 March 2009 04:15 Go to next message
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
Senior Member
I have a txt which contain data for multiple table which delimeter as " § "

I have a bit of confusion to insert the record into multiple table can anyone help me to sort this problem and post me how to write control file for this scenario.

The given may change or the tables may not contain the data.


Header

1§00§Table_1§
1§50§E1§Ashok§27§Male§
1§50§E2§Asha§29§Female§
1§50§E3§Ramya§25§Female§
1§50§E4§Maha§25§Female§
1§99§48§

1§00§Table_2§
1§50§E1§IT§PE§
1§50§E2§IT§TT§
1§50§E3§IT§TL§
1§50§E4§IT§PM§
1§99§48§

1§00§Table_3§
1§99§0§



[Updated on: Sun, 29 March 2009 04:28]

Report message to a moderator

Re: SQL LOADER for multiple table [message #394654 is a reply to message #394645] Sun, 29 March 2009 08:47 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Have a look at this.

By
Vamsi
Previous Topic: Load data from thousands of CSV files into one table
Next Topic: SQL Loader Referencing field problem
Goto Forum:
  


Current Time: Sun Apr 28 20:01:39 CDT 2024