Re: Moving LOB Storage and Index

From: <DEEDSD_at_Nationwide.com>
Date: Thu, 10 Jul 2003 03:51:05 -0700
Message-ID: <F001.005C43E1.20030710034424@fatcity.com>

I seem to recall from Jonathan Lewis' book that moving a LOB index after creation was possible in some versions of 8.0, but no longer possible in 8i. Unfortunately, I don't have the book in front of me right now so I can't say for sure.

                                                                                       
                           
                          Munish Bajaj                                                 
                           
                          <[EMAIL PROTECTED]>     T                                    
                          
                                                   To:   Multiple recipients of list 
ORACLE-L                     
                          Sent by:                 <[EMAIL PROTECTED]>                 
                        
                          [EMAIL PROTECTED]    cc:                                     
                       
                                                                                       
                           
                                                   bcc:                                
                           
                                                   Subject:                            
              Moving LOB   
                          07/10/03 12:49 AM        Storage and Index                   
                           
                          Please respond to                                            
                           
                          ORACLE-L

Hi Listers,

I created a table containing a LOB Column (icon) with the following storage clause :

LOB (ICON) STORE AS (TABLESPACE QUARKDMS_BLOB STORAGE(INITIAL 1M NEXT 5M) CHUNK 4K PCTVERSION 10 NOCACHE LOGGING INDEX (TABLESPACE QUARKDMS_INDEX STORAGE (INITIAL 1M NEXT 1M)) DISABLE STORAGE IN ROW); I want to move only the lob-Index from tablespace Quarkdms_index to a new tablespace. Please let me know whether this is possible and the command for the same.

Thanks to all

Best Regards

Munish Bajaj

--

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

Author:
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jul 10 2003 - 05:51:05 CDT