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.