Re: Resize SYSAUX datafile

  • From: Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx>
  • To: ricard.martinez@xxxxxxxxx
  • Date: Wed, 06 Apr 2011 19:49:07 +0200

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: