unable to rename a datafile
Hi all,
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
Re: unable to rename a datafile
Quote:
Originally posted by pnrdba
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.
On second thought, are your sure you get this ORA error when trying to offline the tablespace and not when creating the datafile?
Well, you could just drop the datafile and create it again with a name you want.
Moreover, you need to have a smaller value for INITIAL for the SYSTEM tbs to solve the ORA error you get.
HTH.