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 12.1.0.2 and later
Information in this document applies to any platform.
This note is applicable when using Partitioned LOB

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

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
Symptoms
Cause
Solution
References


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