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: 238
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: Sat Dec 03 16:07:53 CST 2016

Total time taken to generate the page: 0.06583 seconds