From: Mark D Powell <>
Date: Thu, 30 Oct 2008 10:49:05 -0700 (PDT)
Message-ID: <>

On Oct 30, 10:49 am, wrote:
> How do I set the SSM to auto for the SYSTEM tablespace (EXTENT
> MANAGEMENT LOCAL) when creating a new database in

You cannot use ASSM on the system tablespace. It is not supported on version 10g and below. I do not think this has changed on 11g either but have not checked.

Only the extent management can be automatic. You cannot use uniform extents either though the syntax diagram in the SQL manual entry for CREATE DATABASE shows the option. There is a note in the Administration manual though stating uniform extents cannot be used.

HTH -- Mark D Powell -- Received on Thu Oct 30 2008 - 12:49:05 CDT

Original text of this message