Load data from multiple data files into multiple tables using single control file

Question

I have 3 data files and 3 tables. Is there any way to enter the data from the data files to their respective tables using only a single control file using parameters.

I know that we can use multiple datafiles to insert data into single table but i want multiple datafiles to insert data into multiple tables.

Gary_W · Accepted Answer · 2015-03-04 15:16:05Z

0

I have not done it, but you can specify multiple files as long as they are the same layout by using multiple INFILE clauses. Then as long as there is some identifier in the record, you can use multiple INTO TABLE clauses, each with its own WITH clause. See the control file reference for more info. Please let us know how it works out.

answered Mar 4, 2015 at 15:16

Gary_W

10.4k1 gold badge26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Load data from multiple data files into multiple tables using single control file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related