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

    sdlci import utility (sqldeveloper)


      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.