OraFAQ Forum: Server Utilities » SQL*LOADER: Load multiple tables with same record/Fields

Home » RDBMS Server » Server Utilities » SQL*LOADER: Load multiple tables with same record/Fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*LOADER: Load multiple tables with same record/Fields [message #129287]

Sat, 23 July 2005 02:36

mailsush
Messages: 4
Registered: July 2005
Location: Bangalore

Junior Member

Hi,

Can anybody tell me, is it possible to load a same record/Attribute into multiple tables using SQL*LOADER.

Example:
=========================
I have 2 tables, X1 and X2
X1
----------------
A NUMBER
B NUMBER

X2
----------------
C NUMBER
D NUMBER

Data File record is of type:
----------------
1|2|3|4
=========================================
My problem:
i need to load data column value '3' in Table X1 and Table X2 as well.

I tried out loading, but was not succesful.
CONSTARINT being: I cannot use POSITION values as data ex[pected is of variable length

Can anybody get me the solution?

Regards
Sushil

[Updated on: Sat, 23 July 2005 02:39]

Report message to a moderator

Re: SQL*LOADER: Load multiple tables with same record/Fields [message #129488 is a reply to message #129287]

Mon, 25 July 2005 08:00

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

You can use either position values or column names to identify columns in, for example, a when clause.

And yes, you can have multiple into table clauses to specify multiple tables to load data into.

Report message to a moderator

Re: SQL*LOADER: Load multiple tables with same record/Fields [message #131753 is a reply to message #129488]

Tue, 09 August 2005 05:26

mailsush
Messages: 4
Registered: July 2005
Location: Bangalore

Junior Member

Martin,

Thanks for the reply.
But this still does not solve my problem,

As i have data which is of variable length for which i just cannot use POISTION property.

Also, column names were put to use, but was of no use

Regards
Sushil

Report message to a moderator

Previous Topic:	sql loader mapping only specific columns from data file
Next Topic:	Direct Load with nextval clause in Control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 06:13:20 CDT 2024