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: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Have a look at this.
You may use FILLER for skip some columns. Try Google before posting .

Re: Multiple tables data loading [message #432011 is a reply to message #431855] Fri, 20 November 2009 06:57 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Create external tables

Use that in combination with INSERT ALL

Considering you are runnnig the proper Oracle version.
Previous Topic: Problem in import
Next Topic: SQl loader
Goto Forum:

Current Time: Thu Jul 27 04:03:46 CDT 2017

Total time taken to generate the page: 0.08054 seconds