Making the tablespace online
USR0072Jul 24 2012 — edited Jul 24 2012Hi ,
I am trying to make the tablespace online.
But facing the below issues .Need your help.
SQL> alter tablespace XXXXXX online;
alter tablespace XXXXX online
*
ERROR at line 1:
ORA-01115: IO error reading block from file 15 (block # 1)
ORA-01110: data file 15: '/xxxxxx.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
Additional information: 1
Additional information: 1
SQL> alter tablespace XXXXXX read write;
alter tablespace XXXXXXX read write
*
ERROR at line 1:
ORA-01646: tablespace XXXXXX is not read only - cannot make read write
Os Solaris : 5.8
Database ;Oracle 9.2.0.4.0
Thanks
USR0072