In this post we will see how we can insert records in specific partition using sql*loader.

Step 1 : Create a .dat file which contains records

Step 2 : Create .ctl file

In above output we can see I am trying to insert records in L1 partition of TEST_LOADER table.

Step 3 : Prepare a sqlldr script with above two files.

Let us run this command on OS prompt and see what happens.

Step 4 : Let us select from the table and see

So using above steps we can insert records in specific partition.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.