ORA-00740: Datafile Size Of (4397465600) Blocks Exceeds Maximum File Size with BIGFILE tablespace containing LOB partitions (Doc ID 2901195.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

The following error occurred when adding a datafile to a big tablespace:

SYS@ODS2P_1> select TABLESPACE_NAME||' '|| file_name||' '|| bytes/1024/1024||' '|| autoextensible||' '|| maxbytes/1024/1024 from dba_data_files
 where tablespace_name=upper('<BIG TABLESPACE>'); 2


TABLESPACE_NAME||''||FILE_NAME||''||BYTES/1024/1024||''||AUTOEXTENSIBLE||''||MAXBYTES/1024/1024
------------------------------------------------------------------------------------------------------------------------------------
<BIGFILE TABLESPACE> +OLD/DB/DATAFILE/<old datafile> 67108736 YES 67108863.953125


SYS@ODS2P_1> alter database datafile '+NEW/DATAFILE/<new datafile>' Autoextend ON maxsize 67100G;
 alter database datafile '+NEW/DB/DATAFILE/<new datafile>' Autoextend ON maxsize 67100G
*
ERROR at line 1:
ORA-00740: datafile size of (4397465600) blocks exceeds maximum file size

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.