Oracle Error (ORA-01691), single data file size limit issue

1. Issue: An error occurred while the database was synchronizing a large table from another library

3 : ORA-24801 in OCI lob Functionora-02063 from Piclinkora -016918192 in Tablespace tsp_webagent

2. Problem Analysis:

The following is an official Oracle error code

ora-01691string. string string inch string   for in tablespace. Action:use ALTER tablespace Add datafile statement to add one or more files to the tablespace indicated.

When Tablespace MaxSize Unlimited:

In a Linux system, the maximum size of the (smallfile) data file is 32GB in case the block size is 8K.

When the table space size has a value set (MAXSIZE 4096m):

The value of the data size threshold pre-set.

3. Workaround:

A. When the data file size has set value (MAXSIZE 4096m): Increase the data file size, maximum not more than 32G.

' file path ' autoextend on next 100m maxsize 10240M;

B. When tablespace MaxSize Unlimited: Only new data files can be added.

' data file path ' size 1000m autoextend on next 100m maxsize UNLIMITED;

Oracle Error (ORA-01691), single data file size limit issue