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!

Making the tablespace online

USR0072Jul 24 2012 — edited Jul 24 2012
Hi ,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2012
Added on Jul 24 2012
4 comments
388 views