DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jul 2010

    Post Load the data file name in the column of table using sqlloader

    I have set of files in a folder, all the data present in these files should be loaded in the oracle database through sql loader. The no of files present in that folder may change day by day. I have two problems.
    1. All the files should be loaded into the database without specifying the file name in the control file. (dynamically the filename should change).
    2. The data file name should be loaded in the column of the table along with the data.
    Kindly give me any suggestions for this. Prefarably any unix shell script.


  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    What's wrong with script LK_Brwn provided as an answer to previous post?
    It certainly solves question #1
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.