Question Locked

Oracle XE data block corrupted

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have oracle XE installed on solaris 10
When i try to create new table it gives me error ORA-01658: unable to create INITIAL extent for segment in tablespace USERS

to fix this problem i am trying to alter the tablespace
the datafile exists at '/usr/lib/oracle/xe/oradata/XE/users.dbf'

I tried
****
alter tablespace USERS alter datafile '/usr/lib/oracle/xe/oradata/XE/users.dbf' autoextend on next 100m maxsize 2000m offline;

result :- ORA-02142: missing or invalid ALTER TABLESPACE option

****
alter database datafile
'/usr/lib/oracle/xe/oradata/XE/users.dbf' autoextend on
Result:- ORA-01578: ORACLE data block corrupted (file # 4, block # 2)

Please help.
Thanks in advance
alphamn

2 replies

by dr dij

As I recall from the large versions - 9, 10 you can have multiple tablespaces on several disk drives. Why don't you try creating another somewhere else?

Sounds like you are just setting it up? If not you should have a backup before it was corrupted I hope if you have any tables you need to recover? Also ittoolbox has specific oracle groups for asking questions. You may want to ask question there as questions here scroll off and disappear quickly.

http://oracle.ittoolbox.com/groups/

This discussion is closed to new replies.