Home » RDBMS Server » Server Administration » Temporary segment in Permanent tablespace
Temporary segment in Permanent tablespace [message #151398] Wed, 14 December 2005 11:36 Go to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

I wish to know under what circumstances/conditions would the temporary segment be created in permanent tablespaces??

Regards,
reena

Report message to a moderator

Re: Temporary segment in Permanent tablespace [message #151399 is a reply to message #151398] Wed, 14 December 2005 11:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
NONE

Report message to a moderator

Re: Temporary segment in Permanent tablespace [message #151515 is a reply to message #151399] Thu, 15 December 2005 04:34 Go to previous messageGo to next message
sharan_it
Messages: 140
Registered: July 2005
Location: Chennai
Senior Member
To use temporarily..

Report message to a moderator

Re: Temporary segment in Permanent tablespace [message #151580 is a reply to message #151398] Thu, 15 December 2005 14:14 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
In some situations, such as while creating an index, oracle will do so as a temporary index until it is finished, then rename it to the proper name. But I believe it is only a rename, meaning the segment itself is a perm segment type, but the name has a funky temporary name, if that is what you mean.

Report message to a moderator

Re: Temporary segment in Permanent tablespace [message #151719 is a reply to message #151580] Sun, 18 December 2005 11:33 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

How bout cases where temporary segment is not available when required?? Can't a permanent tablespace be use at that time?? I have read in OCP study guide(By Biju Thomas)that temporary segments in permanent tablespace are created on the fly and allocation is removed when the transaction completes..(conditions not mentioned)

Regards
reena

Report message to a moderator

Re: Temporary segment in Permanent tablespace [message #151874 is a reply to message #151398] Mon, 19 December 2005 09:49 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Sounds like what you are describing is the same as what I was talking about right above.

But oracle isn't going to use a perm tablespace for standard temp space type activities such as sorting.

Report message to a moderator

Previous Topic: Need Help in creating Index
Next Topic: How To Find User quota
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 17:14:44 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.