OraFAQ Forum: Server Utilities » Mulitple tables data loading

Home » RDBMS Server » Server Utilities » Mulitple tables data loading

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

Mulitple tables data loading [message #431848]

Thu, 19 November 2009 12:12

swathi karre
Messages: 4
Registered: November 2009
Location: hyderabad

Junior Member

I have a data file which need to appended in multiple tables.

For example.

In data file there are 5 columns.
Last column should be appended in first table,last two columns should be appended in second table and all the columns should be appended in third table.

Please help me to resolve this problem

Report message to a moderator

Re: Multiple tables data loading [message #431855 is a reply to message #431848]

Thu, 19 November 2009 12:35

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Have a look at this.
You may use FILLER for skip some columns. Try Google before posting .

By
Vamsi

Report message to a moderator

Re: Multiple tables data loading [message #432011 is a reply to message #431855]

Fri, 20 November 2009 06:57

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Create external tables
link

Use that in combination with INSERT ALL
link

Considering you are runnnig the proper Oracle version.

Report message to a moderator

Previous Topic:	Problem in import
Next Topic:	SQl loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 01:30:25 CDT 2024