Re: Compute_statistics PROBLEM

"Howard J. Rogers" wrote:

> > I'm with Pete on this one. I'd create a third TEMP while doing the repair
> work ...
> > not screw up another application. Then shift them back and drop the third
> TS.
> >
> > Your comments will be appreciated.
>
> It's a matter of principle. Something which is called a "default" is, as we
> all know and appreciate, something that gets used when nothing else fits the
> bill... DBA forgot to specify a temp. tablespace, storage clause wasn't
> specified for a table, etc etc.
>
> All of a sudden, the database's "DEFAULT" temporary tablespace doesn't mean
> that at all. It now means "something I'll apply if you omit to mention an
> alternative, and something that might happen to all those accounts for which
> you *did* remember to specify something, but I don't care because that's the
> way I work".
>
> That's not right. A default should be something to fall back on, not
> something which, by changing, you alter the details for (potentially)
> hundreds of users you've already carefully set up.
>
> <stuff snipped>
>
>
> Regards
> HJR
I thought d' fault was what caused the problem in the first place.

Daniel Morgan Received on Tue Jan 28 2003 - 00:01:00 CST