unable to rename a datafile
I'm running oracle 9.0.1 on linux 6.2. I was adding a datafile to a tablespace and was wrongly typed the name of the datafile. I thought of renaming the file and tried to took the tablespace offline.I got an error ORA-01658,"unable to create INITIAL extent for segment in tablespace SYSTEM", this tablespace has got only 300M left over, and even that directory doesn't got much physical space on disk to increase the system TS size. Can you please help me.
Thanks in advance
Click Here to Expand Forum to Full Width