Oracle報ORA-01691錯誤,單個資料檔案大小限制問題

來源:互聯網
上載者:User

Oracle報ORA-01691錯誤,單個資料檔案大小限制問題

1.問題:Oracle資料庫從其他庫同步一張大表時,出現錯誤

ERROR at line 3:

ORA-24801: illegal parameter value in OCI lob function

ORA-02063: preceding line from PICLINK

ORA-01691: unable to extend lob segment WEBAGENT_PIC.SYS_LOB0000087483C00004$$ by 8192 in tablespace TSP_WEBAGENT

2.問題分析:

下面是oracle官方錯誤碼

ORA-01691 unable to extend lob segment string.string by string in tablespace string

Cause: Failed to allocate an extent for LOB segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

當資料表空間MAXSIZE UNLIMITED時:

linux系統中,在block size為8K的情況下,(smallfile)資料檔案的最大size為32GB。

當資料表空間大小有設定數值時(MAXSIZE 4096m):

資料大小臨界預先設定的值。

3.解決方案:

a.當資料檔案大小有設定數值時(MAXSIZE 4096m):增加資料檔案大小,最大不超過32G。

alter database datafile '檔案路徑' autoextend on next 100m maxsize 10240M;

b.當資料表空間MAXSIZE UNLIMITED時:只能新添加資料檔案。

alter tablespace xxx add datafile '資料檔案路徑‘ size 1000m autoextend on next 100m maxsize UNLIMITED;

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.