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
Received on Mon Aug 13 2007 - 01:20:35 CDT
