> 
> Hai,
>      This is Regarding TRUNCATE.=20
> 
> I have the table =C9MP' with 15 records.
> 
> How do I delete the the Records alone using 'TRUNCATE' Command.
> 
> Thanks
> 
> fazal
> 
Fazal,

The syntax is:

TRUNCATE TABLE table_name;

Note that this is much quicker than the DELETE command below:

DELETE FROM table_name;

It is quicker because Oracle simply resets a high-water mark and frees up
newly freed extents. It does not use REDO functionality, and no triggers are
fired (if there are any for BEFORE/AFTER DELETE).

Best regards,


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 245+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ck to Ari Kaplan's Home Page