Home » SQL & PL/SQL » SQL & PL/SQL » Renaming Tablespace name
Renaming Tablespace name [message #201019] Thu, 02 November 2006 04:34 Go to next message
Messages: 1
Registered: November 2006
Junior Member
Hi all,

I am trying to rename my tablespace name using the following command:
The following error is noticed --> "ORA-01904: DATAFILE keyword expected".

Then i tried with ...
ALTER TABLESPACE OLD_TablespaceName RENAME TO NEW_TablespaceName DATAFILE 'path of my datafile';
No progress in this command too.

I want to use the same datafile associated with my existing tablespace.My requirement is to only change the tablespace name.
Can anyone help me in this regard.
Re: Renaming Tablespace name [message #201024 is a reply to message #201019] Thu, 02 November 2006 04:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
That should work only in 10g.
SCOTT >alter tablespace users rename to users01;

Tablespace altered.
Re: Renaming Tablespace name [message #201026 is a reply to message #201019] Thu, 02 November 2006 04:51 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Who told you that you could rename tablespaces, and why exactly would you need to?

As far as I'm aware, you can't, and the only thing you could do would be to create a new tablespace, move all the objects over, and then drop the old tablespace and datafiles. That doesn't allow your other objective of reusing the datafile, but it's about as near as I think you're going to get.
Previous Topic: Returning All Duplicate Rows
Next Topic: Using alias
Goto Forum:

Current Time: Sat Oct 22 07:02:29 CDT 2016

Total time taken to generate the page: 0.08500 seconds