STORAGE_IN_ROW parameter

Hi,
I am using Oracle 9i (9.2.0.3) and have a vary large partitioned table containing a LOB column. The table is partitioned based on the insert_date into 4 partitions (one for for each quarter of the year).

While the table was created, the STORAGE_IN_ROW parameter was disabled but when we query the USER_LOBS for details for this table, the IN_ROW column specifies that the STORAGE_IN_ROW is enabled. Also is it possible to change the STORAGE_IN_ROW parameter after the table is created.

Thanks
S.Prabhakar

Do you use a separate tablespace for LOB column ?

Tamil