OraFAQ Forum: SQL & PL/SQL » Rename Tablespace

Home » SQL & PL/SQL » SQL & PL/SQL » Rename Tablespace (Oracle 11.2.0.3.0 ,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rename Tablespace [message #610230]

Tue, 18 March 2014 11:37

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi ,

Can you tell me what are all the tablespaces that can be renamed ?

Thanks,
Jack

Report message to a moderator

Re: Rename Tablespace [message #610232 is a reply to message #610230]

Tue, 18 March 2014 11:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

still unwilling or incapable to Read The Fine Manual yourself?

http://docs.oracle.com/cd/E16655_01/server.121/e17636/tspaces.htm#ADMIN01104

Report message to a moderator

Re: Rename Tablespace [message #610234 is a reply to message #610232]

Tue, 18 March 2014 11:48

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi Blackswan,

Thanks for the link. It seems only Undo tablespace can be renamed.

Report message to a moderator

Re: Rename Tablespace [message #610235 is a reply to message #610234]

Tue, 18 March 2014 11:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

besides be lazy, I see that you are also inept at reading & comprehending written English

"If the tablespace being renamed is the SYSTEM tablespace or the SYSAUX tablespace, then it will not be renamed and an error is raised."

Report message to a moderator

Re: Rename Tablespace [message #610237 is a reply to message #610235]

Tue, 18 March 2014 11:52

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

"If the tablespace being renamed is the SYSTEM tablespace or the SYSAUX tablespace, then it will not be renamed and an error is raised."

means SYSTEM and SYSAUX tablespaces cannot be renamed .Is my understanding is correct ?

Report message to a moderator

Re: Rename Tablespace [message #610238 is a reply to message #610237]

Tue, 18 March 2014 11:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>means SYSTEM and SYSAUX tablespaces cannot be renamed .Is my understanding is correct ?
what happens when YOU try to do it?

Report message to a moderator

Re: Rename Tablespace [message #610239 is a reply to message #610238]

Tue, 18 March 2014 11:58

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

then it will not be renamed and an error is raised.

Report message to a moderator

Re: Rename Tablespace [message #610240 is a reply to message #610239]

Tue, 18 March 2014 12:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It seems only Undo tablespace can be renamed.
WRONG!
some, many, most tablespaces can be renamed.

Report message to a moderator

Re: Rename Tablespace [message #610377 is a reply to message #610240]

Wed, 19 March 2014 11:15

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan

>some, many, most tablespaces can be renamed.

Can you name those tablespaces ?

Report message to a moderator

Re: Rename Tablespace [message #610383 is a reply to message #610377]

Wed, 19 March 2014 12:23

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All of them but those that are excluded as specified in the documentation.

[Updated on: Wed, 19 March 2014 12:23]

Report message to a moderator

Previous Topic:	Data validation in staging table
Next Topic:	Replace Date column to Varchar Value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:01:26 CDT 2024