Richard, Do you want to increase the size of the SYSAUX datafile or reduce it? Dennis Williams On Wed, Apr 6, 2011 at 12:49 PM, Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx > wrote: > 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 > > >