How to truncate the data in one partition

Posted in 2009

CHUAN LU — Mon, 27 Jul 2009 09:07:02 — source: IIUG Forums & Mailing Lists

On the partitioned table, How to truncate the data in one of the partitions? (not using the detach)?

↪ replying to CHUAN LU

Art Kagel — Mon, 27 Jul 2009 13:15:02 — source: IIUG Forums & Mailing Lists

You can use DELETE FROM with an appropriate WHERE clause or you can DETACH the fragment to a table, TRUNCATE it and then ATTACH it back onto the original table. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 27, 2009 at 5:07 AM, CHUAN LU <luchuan114@sina.com> wrote: > On the partitioned table, How to truncate the data in one of the > partitions? > (not using the detach)? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636988a0bae5d5f046fafbdc7