Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rename tablespace

654586Oct 6 2008 — edited Oct 8 2008
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2008
Added on Oct 6 2008
9 comments
781 views