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 Go to next message
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.
Re: How to Load the data from single file to Multiple tables using SQL* Loader [message #427634 is a reply to message #427626] Fri, 23 October 2009 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just read the topic that is below yours.
And the many other examples that are in the (sub)forum or in the documentation.

Regards
Michel

[Updated on: Fri, 23 October 2009 11:53]

Report message to a moderator

Re: How to Load the data from single file to Multiple tables using SQL* Loader [message #427635 is a reply to message #427634] Fri, 23 October 2009 12:06 Go to previous messageGo to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi Michel,

Thanks but its for fixed position length of column than how to achieve for Delimited Comma separated ?
Re: How to Load the data from single file to Multiple tables using SQL* Loader [message #427637 is a reply to message #427635] Fri, 23 October 2009 12:27 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Same thing, same answer, just try it.
Quote:
And the many other examples that are in the (sub)forum or in the documentation.


Regards
Michel
Previous Topic: SQL*LDR
Next Topic: On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared
Goto Forum:
  


Current Time: Mon Dec 23 13:28:01 CST 2024