Richard Foote wrote:
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:3f743a8c$0$32058$afc38c87_at_news.optusnet.com.au...
>> Steven wrote:
>>
>> > Hi,
>> >
>> > One of my users ran an incorrect query and increased the temporary
>> > tablespace to it's maximum of 4GB. Until now it was static around
400MB.
>> > I want to shrink the temporary datafiles back to their normal size but
>> > I can't
>> > seem to do this. It's won't allow me to.
>> >
>> > I'm using Oracle 9i with Locally managed temporary tablespaces.
>> >
>> > Is is possible now to shrink the datafiles. If so does anyone know how
I
>> > can do this?
>> >
>> > Thanks in advance
>> > Steve,
>> >
>>
>> An excellent demonstration of why autoallocate is a really bad idea!
>>
>> Drop the temporary tablespace altogether and re-create it. And make sure
>> autoallocate is not turned on this time.
>>
> Hi Howard,
>
> You mean autoextend ?
>
> Cheers ;)
>
> Richard
Bugger, yes I did!
Thanks Richard.
Regards
HJR
Received on Fri Sep 26 2003 - 17:56:07 CDT
