Re: Resize SYSAUX datafile
From: Grzegorz Goryszewski <grzegorzof_at_interia.pl>
Date: Wed, 06 Apr 2011 19:49:07 +0200
Message-ID: <4D9CA793.7070707_at_interia.pl>
On 2011-04-06 19:25, Ricard Martínez wrote:
> Hi
> Im trying to do a resize of SYSAUX datafile, but all the info and metalink
> notes im reading, make me think it is impossible for the moment. That the
> only real options is
> to clean space and put tablespace in autoextend off.
> Anyone have been able to do it? Or really isnt allowed atm?
> Thanks
>
Hi,
that's strange . There is nothing special about SYSAUX , You can check what made it big via
|select * from V$SYSAUX_OCCUPANTS and do some cleanups. Can u share ORA- You are hitting ?
Regards.
GregG
Najwiekszy wybor samochodow nowych i uzywanych! Sprawdz >> http://linkint.pl/f2970
Date: Wed, 06 Apr 2011 19:49:07 +0200
Message-ID: <4D9CA793.7070707_at_interia.pl>
On 2011-04-06 19:25, Ricard Martínez wrote:
> Hi
> Im trying to do a resize of SYSAUX datafile, but all the info and metalink
> notes im reading, make me think it is impossible for the moment. That the
> only real options is
> to clean space and put tablespace in autoextend off.
> Anyone have been able to do it? Or really isnt allowed atm?
> Thanks
>
Hi,
that's strange . There is nothing special about SYSAUX , You can check what made it big via
|select * from V$SYSAUX_OCCUPANTS and do some cleanups. Can u share ORA- You are hitting ?
Regards.
GregG
|
Najwiekszy wybor samochodow nowych i uzywanych! Sprawdz >> http://linkint.pl/f2970
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 06 2011 - 12:49:07 CDT