View Single Post
  #2 (permalink)  
Old October 12th, 2004, 10:53 PM
Justin Cave Justin Cave is offline
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you doing this in a production database? If so, what sort of downtime are you allowed?

Unless you have partitioned tables, you wouldn't want to use COALESCE PARTITION. Coalescing a tablespae combines contiguous free extents in a tablespace into one large extent.

What sort of tablespaces do you have? Locally managed or dictionary managed?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC