Home » RDBMS Server » Server Utilities » How to Load the data from single file to Multiple tables using SQL* Loader (Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit)
How to Load the data from single file to Multiple tables using SQL* Loader [message #427626] |
Fri, 23 October 2009 11:10 |
tapaskmanna
Messages: 98 Registered: January 2007 Location: Cyprus,Nicosia
|
Member |
|
|
Hi,
How to Load the data from single file to Multiple tables using SQL* Loader?
Data Files:
-----------
10,abc,xyz
10,def,bgt
20,100,xyz,101
20,101,wyz,102
30,101,wyz,101,101,wyz,101
30,102,wyz,102,102,wyz,102
40,12,20,xyz
40,12,20,xyz
50,abc,xyz
50,abc,xyz
First Filed is table code and respective has the coulmn as per table:
Table Code Table Name
10 Map_Name
20 Globe_Map
30 Tag_Map
40 Get_Map
50 Set_Map
Pls. suggest.
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Dec 23 13:28:01 CST 2024
|