Do you have the temporary tablespace for SYS and SYSTEM set to that
tablespace? There are some instances where the engine itself needs to build
a temporary table that is persistant until the instance is bounced. Your
choices are either to accept that this happens or set temporary tablespace
for SYS and SYSTEM back to the SYSTEM tablespace. I've done it both ways
and have yet to see any adverse effects other than taking up space in the
temporary tablespace.
"David F. Newman" wrote:
>
> Hi,
> I have temporary segments in my temporary
> tablespace (which is marked as temporary) that
> won't go away. They are owned by SYS and they
> stay there even after the database is restarted.
> I was under the impression that temporary segments
> should go away when a database is shutdown. Is
> this not the case? Is there a way to purge temporary
> segments manually?
>
> --
> David F. Newman
> Oracle DBA
> dnewman_at_ourvillage.com
Received on Mon Sep 27 1999 - 15:01:00 CDT
