1 Reply Latest reply on Nov 8, 2019 3:29 AM by michael.sakayeda-Oracle

    SQL Loader log messages in the form: %(1)d %(2)s successfully loaded

    3338633

      I have a Linux service account on my DB server in the "oinstall" group. In 12.1 it ran sql loader scripts with no issues. I upgraded to 12.2 and now all the logs show:

       

      Table MYOWNER.MYTABLE:

        %(1)d %(2)s successfully loaded.

        %(1)d %(2)s not loaded due to data errors.

        %(1)d %(2)s not loaded because all WHEN clauses were failed.

        %(1)d %(2)s not loaded because all fields were null.

       

      No counts!

       

      I suspect this is a file permissions issue but could use any advice.

       

      Thanks