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

Posted on 2006-05-11
Last Modified: 2008-01-09
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.
Question by:rayskelton
    LVL 12

    Expert Comment

    do you mean truncate TABLE or really DATABASE?
    LVL 7

    Expert Comment

      execute immediate 'truncate table tablename;
    LVL 7

    Accepted Solution


    sorry forgot the last part....
       execute immediate 'truncate table tablename';

    Author Comment

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

    'truncate table tablename';

    Author Comment

    truncate as a control file option works good,

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Cursor 5 50
    Mysql vs Oracle 10 105
    Oracle Pivot 8 56
    oracle query help 29 48
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now