DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: STORAGE_IN_ROW parameter

  1. 06-04-2004, 11:05 AM #1
    sprabhakar
    sprabhakar is offline Junior Member
    Join Date
    May 2002
    Posts
    46

    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
    Reply With Quote Reply With Quote
  2. 06-04-2004, 04:26 PM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Do you use a separate tablespace for LOB column ?

    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width