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
