Home » SQL & PL/SQL » SQL & PL/SQL » Truncate and COALESCE
Truncate and COALESCE [message #19575] Thu, 28 March 2002 15:56 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I have my table in tablespace TAB_SPACE and my indexes for that table is in IND_SPACE. Whenever I truncated my table is it necessary to do a COALESCE for the index space IND_SPACE also? otherthan COALESCEing the table space.

Thanks

Uma
Re: Truncate and COALESCE [message #19576 is a reply to message #19575] Thu, 28 March 2002 21:29 Go to previous messageGo to next message
Somu
Messages: 24
Registered: February 2000
Junior Member
Uma,

There is no need to coalesce the tablespace. Unless otherwise if the tablespace extents are high.
Re: Truncate and COALESCE [message #19580 is a reply to message #19575] Fri, 29 March 2002 03:46 Go to previous message
uma
Messages: 67
Registered: May 2001
Member
Really? Once I truncated the table don't I need to COALESCE?

Thanks if it is true.

Uma
Previous Topic: Using a field with low cardinality in a where clause.
Next Topic: ora-06553
Goto Forum:
  


Current Time: Thu Mar 28 17:32:47 CDT 2024