熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

CLOB擴展塊滿出現的錯誤

2013-11-13 16:06:27  來源: Oracle 

  服務器報錯

  ORA max # extents () reached in lob segment NARROWADSYS_LOBC$$ partition SYS_LOB_P

  是因為Oracle表中的CLOB字段的擴展塊設置有問題

  分析服務器報錯

  ORA max # extents () reached in lob segment NARROWADSYS_LOBC$$ partition SYS_LOB_P

  檢查

  select substr(segment_name) Segment_namesegment_typepartition_name
  substr(tablespace_name) Tablepace_nameextents
  Max_extentsbytesblocksINITIAL_EXTENTNEXT_EXTENT
  from dba_segments where segment_name like SYS_LOB%
  order by segment_name

  發現

  SYS_LOBC$$ LOB PARTITION SYS_LOB_P NARROWAD_BASIC_TABLE
  SYS_LOBC$$ LOB PARTITION SYS_LOB_P NARROWAD_BASIC_TABLE

  原因

  需要對CLOB字段單獨進行設置

  ALTER TABLE NAD_ADCustomer_URLLIST MODIFY LOB (URLS) (STORAGE(MAXEXTENTS ))


From:http://tw.wingwit.com/Article/program/Oracle/201311/17816.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.