moving lobsegments and lobindexes

From: George Leonard <leonarge_at_vodacom.co.za>
Date: Tue, 10 Feb 2004 10:00:41 +0200
Message-ID: <99CEA8FB33554B4BAC372CE602F9B7ED02E53C17@zamdh02001.vodacom.corp>

Hi all,  

Don't worry, found the solution.  

First run:  

SELECT owner, table_name, column_name FROM all_lobs WHERE SEGMENT_NAME = 'SYS_LOB0000181363C00001$$';     ALTER TABLE <TABLE_NAME> MOVE LOB(<COLUMN_NAME>) STORE AS lobsegment
(TABLESPACE instats_data160k1 );
   

This will move the lobsegment and lobindex.  

George  

---

 

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)

Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za  

You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!      

“This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp "

---

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 Tue Feb 10 2004 - 02:00:41 CST