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
