<div>
do you mean truncate TABLE or really DATABASE?
</div>


do you mean truncate TABLE or really DATABASE?

<div>
 &nbsp; execute immediate 'truncate table tablename;
</div>


  execute immediate 'truncate table tablename;

<div>
Will this work as control file option in sqlldr or is this a command line option?<br />
<br />
'truncate table tablename';
</div>


Will this work as control file option in sqlldr or is this a command line option?

'truncate table tablename';

<div>
truncate as a control file option works good,<br />
thanks
</div>


truncate as a control file option works good,
thanks

<div>
<div class="content wysiwyg-content">
How do you truncade a database in Oracle sqlldr before loading fresh data. I can do this in sqlplus but would prefer to do inthrough sqlldr. 
</div>
</div>


How do you truncade a database in Oracle sqlldr before loading fresh data. I can do this in sqlplus but would prefer to do inthrough sqlldr. 

How do you truncade a database in Oracle sqlldr before loading fresh data.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.