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

Thread: sql*loader-522 error

  1. #1
    Join Date
    Nov 2000
    Posts
    65

    Unhappy

    Dear DBAs & soon to be DBAs,

    I am running into the following problem .. with sql* loader

    /opt/oracle/8.1.5/rdbms/demo% sqlldr userid=hnmadm/hnmadm control=ulcase2.ctl log=ulcase2.log

    SQL*Loader: Release 8.1.5.0.0 - Production on Thu May 3 19:30:54 2001

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    SQL*Loader-522: lfiopn failed for file (ulcase2.log)

    "SQL*Loader-522" - How does one go about handling this error?

    Note:
    1)The above(ulcase2.ctl) is part of the standard demo scripts that comes with Oracle / location: ..../oracle/8.1.5/rdbms/demo

    2) I did create the demo emp table using the script utlcase1.sql
    before running sql*loader command.


    Thank you in advance for your time & best of Luck,
    NK


  2. #2
    Join Date
    Apr 2001
    Location
    West Sussex, England
    Posts
    15
    Make sure you have write permissions on the directory that you are trying to write the logfile to.

  3. #3
    Join Date
    Nov 2000
    Posts
    65

    Thumbs up

    Thank for the tip!! Markmd
    You were right - It was an issue regarding permissions!!

    NK


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