Load the data file name in the column of table using sqlloader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Load the data file name in the column of table using sqlloader

Hybrid View

  1. #1
    Join Date
    Jul 2010
    Posts
    2

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

    Hi,
    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.

    Thanks
    HIMALAYHAA

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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