Home » RDBMS Server » Server Utilities » Mulitple tables data loading
Mulitple tables data loading [message #431848] Thu, 19 November 2009 12:12 Go to next message
swathi karre
Messages: 3
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
Re: Multiple tables data loading [message #431855 is a reply to message #431848] Thu, 19 November 2009 12:35 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Have a look at this.
You may use FILLER for skip some columns. Try Google before posting .

By
Vamsi
Re: Multiple tables data loading [message #432011 is a reply to message #431855] Fri, 20 November 2009 06:57 Go to previous message
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.
Previous Topic: Problem in import
Next Topic: SQl loader
Goto Forum:
  


Current Time: Thu Sep 29 14:12:13 CDT 2016

Total time taken to generate the page: 0.09750 seconds