Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The 32gb limitation

Citizen_2Jul 16 2012 — edited Jul 17 2012

DB version :11.2.0.2
OS Platform : Linux (RHEL 5.4 , 64 bit)

I was trying to resize a datafile to which is currently 30gb in size.

	ALTER DATABASE DATAFILE '+DG_DATA/panrdb/datafile/hw_sit_data01.dbf' RESIZE 34G
	*
	ERROR at line 1:
	ORA-01144: File size (4456448 blocks) exceeds maximum of 4194303 blocks

I was told that there is a 32gb file size limitation. Our db_block_size is 8k

1. Is this limitaion only in Linux or is this applicable to Solaris and AIX as well ?

2. My datafile was stored in an ASM diskgroup. Although ASM instance runs in the OS , the datafiles are stored in the ASM's own filesystem. So, this shows that the 32gb limit is applicable to ASM as well. Right?

This post has been answered by mbobak on Jul 17 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2012

Added on Jul 16 2012

#general-database-discussions

7 comments

6,343 views