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