ORA-01144 on Create Tablespace or Resize of Datafile (Doc ID 104280.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

symptom: ORA-01144: File size %n blocks exceeds maximum of 4194303 blocks
cause: The specified file size is larger than the maximum allowable size. On RDBMS releases 8.0.x through 10.2.x, the maximum number of blocks limited per data file is 2^22-1 (4194303). Some platforms also limit the maximum data file size and the db_block_size. There are also Oracle database limits on the maximum data file size on certain platforms. For example, for RDBMS version 8.0.5 on HP-UX release 11.0, the maximum data file size is limited to 64Gb.

Changes

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!

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

ORA-01144 on Create Tablespace or Resize of Datafile (Doc ID 104280.1)

Applies to:

Symptoms

Changes

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!