TRUNCATE TABLE in PL/SQL

From: Robert Martin <rmartin_at_mindspring.com>
Date: 1995/05/25
Message-ID: <rmartin.9.0016732B_at_mindspring.com>#1/1

Is it possible to do a TRUNCATE (or something equivalent) from within a PL/SQL program? I'm having to do a lot of DELETE <table_name>; COMMIT; on large tables and it is extremely slow compared to TRUNCATE. Received on Thu May 25 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Chakrapani Venkatesan: "Re: TRUNCATE TABLE in PL/SQL"
Previous message: Peter Farrell: "Performance problems on OpenVMS : Was Re : Performance Tolls"
Next in thread: Chakrapani Venkatesan: "Re: TRUNCATE TABLE in PL/SQL"
Reply: Chakrapani Venkatesan: "Re: TRUNCATE TABLE in PL/SQL"
Reply: stowe_at_mcs.net: "Re: TRUNCATE TABLE in PL/SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message