Re: undo tablespace keeps growing, why can't I reclaim space?

Hi Hans,

Instead of an insert followed by an update, why not do something like this:

1. create table target_table_copy as (<select clause to include the update and inserts>)
2. apply any necessary constraints to target_table_copy
3. drop target_table
4. rename target_table_copy to target_table

Regards,
Arun Received on Mon Aug 15 2005 - 09:26:46 CDT