SYSAUX

From: <co4770_at_yahoo.com>
Date: Sun, 12 Aug 2007 22:58:57 -0700
Message-ID: <1186984737.644427.239520@z24g2000prh.googlegroups.com>

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.

Move entire contents of sysaux to a separate tablespace
Drop/create sysaux tablespace,
Move contents back to sysaux.

Apreciate expertise.

TIA Received on Mon Aug 13 2007 - 00:58:57 CDT