+ Start a Discussion
Aviator_07Aviator_07 

Data Loader Command Line - Deletion from Database

Can someone tell me how to Delete data from Oracle table using Data loader command line interface? Is it possible?

 

I found the Sample code for deletion in Apex Data loader Database.xml sample file but I do not know how it is supposed to be called in the Process.conf File and what parameters need to be set.

 

<bean id="deleteAccountAll"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="deleteAccountAllSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>

<bean id="deleteAccountAllSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            DELETE FROM TableOwner.Accounts
        </value>
    </property>
</bean>