RE: Locally Managed Tablespace Survey

Hi Gaja !

>My point is that, the temp segment really does not get dropped
>after 2 hours even after SMON wakes up, at least I have not seen
>it do that. I have gone days waiting for this to occur, but in
>vain.

If my memory serves right there is an
intenral event called "DROP_SEGMENTS"
(can be used with alter system i guess)
which FORCES the cleanup in temp segments.

K Gopalakrishnan
Bangalore, INDIA
http://www.geocities.com/kgkrish Received on Thu Jun 22 2000 - 15:35:52 CDT