Skip to Main Content
Forums

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 commit

BommiApr 15 2015 — edited May 8 2015

Hi Experts,

     I have small doubt with SQL Loader.

     While working with SLQ Loader Program, do we have to mention the 'commit' in the package after calling the SQL Loader Program?

     For example,

          1. I am using the 'Direct Path Load' and didn't mention the 'commit' in my package after calling this Loader Program. Then what will be the result? Does the data is stored in staging table?

          2. I am using the 'Conventional Path Load' and didn't mention the 'commit' in my package after calling this Loader Program. Then what will be the result? Does the data is stored in staging table?

          3. Also,

                    whether it is 'Direct Path Load' or 'Conventional Path Load' or

                    whether I mentioned 'rows=xxx' in control file or not or

                    whether I added 'commit' in my package or not after calling the Loader Program,

               What will be the status of data in Staging Table, if there is any errors during the SQL Loader.

Thanks in Advance,

Bommi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2015
Added on Apr 15 2015
#database-key-features, #export-import-sql-loader-external-tables
1 comment
1,039 views