# How to truncate a particular table in oracle db automatically with ansible code can you please suggest .

**URL:** <https://forum.ansible.com/t/how-to-truncate-a-particular-table-in-oracle-db-automatically-with-ansible-code-can-you-please-suggest/30234>\
**Category:** Ansible Project\
**Created:** [May 1, 2019, 8:28pm UTC](https://forum.ansible.com/t/how-to-truncate-a-particular-table-in-oracle-db-automatically-with-ansible-code-can-you-please-suggest/30234 "2019-05-01T20:28:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chandrasekhar\_Mallis](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@chandrasekhar\_Mallis](https://forum.ansible.com/u/chandrasekhar_Mallis)\
**Post date:** [May 1, 2019, 8:28pm UTC](https://forum.ansible.com/t/how-to-truncate-a-particular-table-in-oracle-db-automatically-with-ansible-code-can-you-please-suggest/30234/1 "2019-05-01T20:28:24Z")

</div>

Requirement : we are in the process of automating the SSL feature in Cognos 11 analytics in that as a first step we need to truncate a table in oracle db

Can any one add the Ansible code for truncating a table in oracle with ansible code this would of great help