Skip to Main Content
Forums

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!

ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

RHKSep 3 2012 — edited Sep 3 2012
Hello all,

Wen i try to add new datafile(32GB) to tablespace i found the below error. I have space available in my disk, why i am not able to add new datafile to tablespace?

ERROR at line 1:
ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks

here is my db_block_size information:


NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192


How can i add new datafile with out any issues.


Regards,
RHK
This post has been answered by kuljeet singh - on Sep 3 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2012
Added on Sep 3 2012
#11g, #general-database-discussions
4 comments
23,717 views