Truncate can do the job. But I hope You Know what You are doing and to achive NT Sent via BlackBerry by AT&T -----Original Message----- From: "Vinod Gopinath BMMI IT" <vinodg@xxxxxxxxxxx> Date: Sun, 12 Oct 2008 12:20:48 To: <askdba@xxxxxxxxxxxxx> Subject: [askdba] Purge Data in APPS 11.5.10.2 How can I purge the data in the tablespaces mentioned below: 1. APPS_TS_SUMMARY 2. APPS_TS_QUEUES 3. APPS_TS_TX_DATA