Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00603: ORACLE server session terminated by fatal error

user3636719Oct 5 2011 — edited Oct 5 2011
I am getting below error,
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for HPUX: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

SQL> create index idx_index5 on user.newtable1 (column1) tablespace tablespace_index_01;
create index idx_index5 on user.newtable1 (column1) tablespace tablespace_index_01;                                          *
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error


SQL> exit
According to suggestion that I got from all great blogs, I saw log file, below is my log file
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
But, There is enough space allocated for tablespace_index_01 abut 55Gig, and table user.newtable1 is about 80Gig.

I am not sure why I am still getting No space left on device error.

Any suggestions greatly appreciated.
This post has been answered by mseberg on Oct 5 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2011
Added on Oct 5 2011
33 comments
30,878 views