Oracle error (ORA-01691), single data file size limit problem,
1. Problem: an error occurs when the database synchronizes a large table from another database.
ERROR at line 3:ORA-24801: illegal parameter value in OCI lob functionORA-02063: preceding line from PICLINKORA-01691: unable to extend lob segment WEBAGENT_PIC.SYS_LOB0000087483C00004$$ by 8192 in tablespace TSP_WEBAGENT
2. Problem Analysis:
The following is the official oracle error code
ORA-01691 unable to extend lob segment string.string by string in tablespace stringCause: 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.
When the tablespace MAXSIZE is UNLIMITED:
In linux, when the block size is 8 K, the maximum size of the (smallfile) data file is 32 GB.
When the tablespace size has a set value (MAXSIZE 4096 m ):
The pre-set value of the critical data size.
3. solution:
A. When the data file size has a set value (MAXSIZE 4096 m): Increase the data file size to a maximum of 32 GB.
Alter database datafile 'file path 'autoextend on next 100 m maxsize 10240 M;
B. When the tablespace MAXSIZE is UNLIMITED: only new data files can be added.
Alter tablespace xxx add datafile 'data file path 'size 1000 m autoextend on next 100 m maxsize UNLIMITED;