Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYSAUX

Re: SYSAUX

From: <co4770_at_yahoo.com>
Date: Sun, 12 Aug 2007 23:40:25 -0700
Message-ID: <1186987225.849884.307760@l22g2000prc.googlegroups.com>


On Aug 13, 11:20 am, Terminator <kramakrishnab..._at_gmail.com> wrote:
> On Aug 13, 10:58 am, co4..._at_yahoo.com wrote:
>
> > Is there a way to recreate SYSAUX tablespace in 10g, This is requred
> > since I need to change extent size to smaller size to save space.
> > Without recreating tablespace changing extent is not possible. Is
> > there any work around to do the following.
>
> > 1. Move entire contents of sysaux to a separate tablespace
> > 2. Drop/create sysaux tablespace,
> > 3. Move contents back to sysaux.
>
> > Apreciate expertise.
>
> > TIA
>
> Which tablespace extent do you want to change.
> Do you want to change the SYSAUX extent size or any other tablespace.
>
> Regards
> Ramakrishna

Yes, I want to change extent size of SYSAUX Received on Mon Aug 13 2007 - 01:40:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US