I'm not absolutely positive, but I don't think you have to bounce the DB
when you repoint your temp segments-- just take the temp TS offline, then
put it back online. It may vary by version, but I think all the segements
previously created will be gone.
Kenneth C Stahl wrote in message <37F0E095.150B8686_at_Unforgettable.com>...
>Not necessarily. I've seen this type of thing many times. There really
>doesn't seem to be any rhyme or reason as to why segments are built at a
>particular location.
>
>I suspect (but have not been able to prove) that if you were to do a ALTER
>TABLESPACE COALESCE it would probably reset things so that Oracle would
>start at the first empty block, but there doesn't seem to be any guarentees
>of that either. The thing that appears to be happening here is the engine
>itself is building temporary segments for its own purposes and that may be
>perfectly valid under any number of circumstances so the question becomes
>whether you hide them away in the SYSTEM tablespace and forget they even
>exist or tolerate them being in the designated tablespace for temporary
>segments chiefly used by user applications.
>
Received on Tue Sep 28 1999 - 18:57:47 CDT
