Oracle Reports ORA-01691 error, single data file size limit problem

Oracle Reports ORA-01691 error, single data file size limit problem

1. Problem: an error occurs when the Oracle database synchronizes a large table from another database.

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. Problem Analysis:

The following is the official oracle error code

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.

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;