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.

• Original Message ----- From: Tapan Trivedi To: oracle-l_at_freelists.org Sent: Thursday, February 26, 2004 2:39 AM Subject: Can existing tablespaces be converted to Automatic Space Segment Management

    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