rename tablespace
654586Oct 6 2008 — edited Oct 8 2008I am not able to rename a tablespace.
I carelessly created a new tablespace as following
create tablespace logging datafile '$ORACLE_HOME/oradata/new.dbf' size 100M;
Here i forgot to mention the tablespace name. Now when i try to rename the tablespace i am not able to get the existing tablepace name because the following yields
select TABLESPACE_NAME from dba_data_files where FILE_NAME='$ORACLE_HOME/oradata/new.dbf';
TABLESPACE_NAME
------------------------------
LOGGING
whereas the alter statement yields
alter tablespace logging rename to new;
alter tablespace logging rename to new
***
ERROR at line 1:
ORA-01904: DATAFILE keyword expected
I am using Oracle 9i on an SunOS machine.Please suggest.
Regards,
Shiva