OraFAQ Forum: Server Administration » Change temp TBS to permanent TBS

Home » RDBMS Server » Server Administration » Change temp TBS to permanent TBS

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

Change temp TBS to permanent TBS [message #183640]

Fri, 21 July 2006 12:30

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

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

I guess you can, however, it's definitely not recommended. Why do you want to convert it to permanent?

Report message to a moderator

Re: Change temp TBS to permanent TBS [message #183928 is a reply to message #183640]

Mon, 24 July 2006 07:40

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.

Report message to a moderator

Re: Change temp TBS to permanent TBS [message #184168 is a reply to message #183659]

Tue, 25 July 2006 10:30

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.

Report message to a moderator

Previous Topic:	LOB
Next Topic:	configuring listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:31:45 CDT 2024