sprabhakar
06-04-2004, 12:05 PM
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
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