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,
SQL> I know you cannot convert but recreate the tablespace. But how about SYSTEM?
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