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.