1

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.

user4215256
  • 25
  • 8

1 Answers1

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.

Gary_W
  • 9,933
  • 1
  • 22
  • 40