R
Ruanne Cluer
Guest
James, Maybe a matter of terminology here. There's no utility to remove a storage area per se. Storage areas contain database objects (tables, indexes, lobs) And are made up of one or more extents. If you're removing the entire Storage Area, first truncate the area to move the HWM back to the first extent: "proutil dbname -C truncate area [area-name]" ( a neat trick to delete all data in a storage area btw leaving the objects in state for the next data load ) proutil dbname -C truncate bi Rebuild only the primary indexes for the table(s) in the area truncated (fast, there's no data) Delete the related table/indexes from the Data Administration tool. Truncate the bi file again. Remove all the extents of an Area (yes, one at a time in decreasing order which should of course be scripted 
hth
Continue reading...
hthContinue reading...