Home » RDBMS Server » Server Utilities » SQL LOADER for mutiple record type from single file
SQL LOADER for mutiple record type from single file [message #74350] Mon, 22 November 2004 11:44
Ganesh
Messages: 31
Registered: November 2000
Member
Hi

I need to load the sample records from a single file to three different tables. Hw can I do this?????

File Format1:

Record type CHAR(5), NameCHAR(4)

ONE01,GANESH

File Format2:

Record Type CHAR(5), VALUE Number(2)

TWO02,90

FILE Format3:

Record Type CHAR(5), Volume Number(3)

THREE1,900

 

Need load each record type to a different table from a single file.

Sample data from file.

ONE01,GANESH

TWO02,90

THREE1,900

 

Help pls

Cheers

Ganesh

 

 

 

 

Report message to a moderator

Previous Topic: Re: Error 1053: The service did not respond to the start or control request in a timely fashion.
Next Topic: Re: IMP-00069 Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:27:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.