Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can existing tablespaces be converted to Automatic Space Segment Management

Re: Can existing tablespaces be converted to Automatic Space Segment Management

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 26 Feb 2004 06:22:34 +0200
Message-ID: <21ed01c3fc20$2935a380$73f823d5@porgand>


No you can't since segment structures in ASSM tablespaces are somewhat different than in freelist managed tablespaces. The change isn't quite trivial as with LMT conversion... You have to move away your segments and recreate the tablespaces.

Tanel.

    Can this be done for existing tablespaces ? I know that new tablespaces can be created with this option on but what about the ones I already have ?

    Tapan Trivedi



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Feb 25 2004 - 22:19:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US