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!

Table Update using SQL Loader

963739Jun 3 2013 — edited Jun 3 2013

Hi All,

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

I am working on Loading a file using SQL Loader.

I have loaded all the records (20Million) in to a table which has 30 columns.

Issue : Now i got a new layout for same Data file, Which already has 5 new columns at the end which we didn't loaded.

I have created the CTL file with New columns but can i update only those 5 new columns into the table. Is that Possible?

Or should i truncate and do it from the scratch....Please suggest me...

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2013

Added on Jun 3 2013

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

1 comment

832 views