0 Replies Latest reply on Oct 13, 2016 3:03 AM by user13537325

    sdlci import utility (sqldeveloper)

    user13537325

      I am using sdcli utility of sqldeveloper to import data from spreadsheet into oracle database tables on linux platform. It's all working fine except when it imports the data it creates a bad file named like (Import....bad.sql) . this bad file is created in default directory where sdcli script is placed (/sqldeveloper/sqldeveloper/sqldeveloper/bin).

       

      My question is , can we specify the name name and location of bad file while using sdcli ?

       

      I am using this command to run the sdcli

       

      /ofa/pkg/oracle/sqldeveloper/sqldeveloper/sqldeveloper/bin/sdcli utility import -config /ofa/pkg/oracle/Excel_Data_Load.sdimp -data /obid/global/inbound/Test_xlsx_Report_2016-10-12-10-00-52.xlsx

       

      Kindly let me know should you need any more details.