Home » RDBMS Server » Server Administration » Re: Temp Tablespace not being flushed automatically
Re: Temp Tablespace not being flushed automatically [message #50828] Tue, 09 April 2002 11:41
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Kishore,

When the temp space is full try the command

alter tablespace temp default storage (pctincrease 0);

and then see the temp space. It will go down to 0, provided no one is doing anything.

Works for me. I cannot recycle the production database in the middle of the day.

Report message to a moderator

Previous Topic: Re: problems with rman oracle 9i
Next Topic: Re: problems with rman oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:24:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.