Rem    NAME 
Rem      jrlob.sql
Rem    DESCRIPTION
Rem      Alters tables and add LOBS / INDEXES 
REm    RETURNS
Rem 	 None
Rem    NOTES
Rem      Please not that if you try to run this script via SQL*Plus 
Rem      You will get errors with the LOBINDEXES
Rem      This is because a ")" is missing so that the RAU can append the 
Rem      Appropiate storage clause
Rem    CREATED
Rem	  13/05/1999

REM ADDING LOBS...

--RAU CONTENTS_BLOB  
ALTER TABLE I$SDD_FILES ADD (CONTENTS_BLOB BLOB)   
       LOB (CONTENTS_BLOB)  
       STORE AS CONTENTS_BLOB 
       (  TABLESPACE %s
          STORAGE ( %s ) 
          CHUNK 4
          NOCACHE
          LOGGING
          INDEX CONTENTS_BLOB_IDX )
/ 

REM ADDING LOB INDEXES...
--RAU CONTENTS_BLOB_IDX 
ALTER TABLE I$SDD_FILES MODIFY (CONTENTS_BLOB) 
  LOB (CONTENTS_BLOB)  
  STORE AS (INDEX CONTENTS_BLOB_IDX STORAGE ( %s ) )
/ 

 

