SEGMENT_SPACE_MANAGEMENT auto

From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 29 Dec 2009 09:34:29 -0600
Message-ID: <eb64345d0912290734p21f3002s685ab5b1a11c4016_at_mail.gmail.com>

Hi,

Is there any significant benefit to "convert" the following to AUTO SEGMENT_SPACE_MANAGEMENT? SQL> select tablespace_name, SEGMENT_SPACE_MANAGEMENT   2 from dba_tablespaces
  3 where SEGMENT_SPACE_MANAGEMENT != 'AUTO';

TABLESPACE_NAME                SEGMEN


------------------------------ ------

SYSTEM                         MANUAL
UNDO                           MANUAL
TEMP                           MANUAL

SQL> I know you cannot convert but recreate the tablespace. But how about SYSTEM?

Thanks,

Roger Xu

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 29 2009 - 09:34:29 CST