My Oracle Support Banner

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

Last updated on AUGUST 23, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
This note is applicable when using Partitioned LOB


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

<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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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