Home » RDBMS Server » Server Administration » Change temp TBS to permanent TBS
Change temp TBS to permanent TBS [message #183640] Fri, 21 July 2006 12:30 Go to next message
xnick
Messages: 3
Registered: July 2006
Location: Long Beach Ca,
Junior Member
I would like to know if you can change temp tablespace, not just the default one, to a permanent tablespace? I am using Oracle 10g DB. Any help will be appreciated.

[Updated on: Fri, 21 July 2006 12:38]

Report message to a moderator

Re: Change temp TBS to permanent TBS [message #183659 is a reply to message #183640] Fri, 21 July 2006 15:44 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
I guess you can, however, it's definitely not recommended. Why do you want to convert it to permanent?
Re: Change temp TBS to permanent TBS [message #183928 is a reply to message #183640] Mon, 24 July 2006 07:40 Go to previous messageGo to next message
jerrysun
Messages: 3
Registered: June 2006
Location: China
Junior Member

drop temp TBS and create a new permanent TBS,i never know other ways to meet your requirement.
Re: Change temp TBS to permanent TBS [message #184168 is a reply to message #183659] Tue, 25 July 2006 10:30 Go to previous message
xnick
Messages: 3
Registered: July 2006
Location: Long Beach Ca,
Junior Member
I am taking Qracle certifation class, so going through all the problems, this was something I was not sure about, Thank you for your help.
Previous Topic: LOB
Next Topic: configuring listener
Goto Forum:
  


Current Time: Sun Dec 11 02:30:46 CST 2016

Total time taken to generate the page: 0.13622 seconds