Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Loader: TRUNCATE INTO one APPEND INTO another

Brian TkatchMar 25 2014 — edited Mar 25 2014

Is it possible to TRUNCATE INTO 5 TABLEs, and APPEND INTO 1, in the same control file?

The APPEND would be the data from the footer, to add to the batch file. The data TABLEs are TRUNCATEd between loads.

This post has been answered by Barbara Boehmer on Mar 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2014

Added on Mar 25 2014

#database-key-features, #export-import-sql-loader-external-tables

2 comments

3,364 views