Re: truncate command 8.1.7. locally managed tablespaces

Howard J. Rogers wrote:
<snip!>
>
> 50% PCTINCREASE has been the default value for Oracle since year dot.
> It's a disgraceful default, and should always be changed to zero,
> without exception.
>

The only exception being SYSTEM in pre-9i (and I'm just stating that because I do not know exactly how 9i would behave) instances. 9i with LMT SYSTEM would be OK, but DMT?

If your system TS (on pre-9i) reaches max_extents, you're likely to get stuck between a rock and a hard place. Saw that happening to a 7.x db once; it came to a grinding halt, and could not be brought back to life, restoring backups was the only option. Cannot think of a reason why that would have been improved in 8.0 or 8i.

Of course, it depends... on the table being hit, for one. But, better safe than sorry.

-- 
Regards, Frank van Bortel