OraFAQ Forum: Server Administration » need help with segment space management

Home » RDBMS Server » Server Administration » need help with segment space management (win 2008 server, 10.2.0.4)

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

need help with segment space management [message #478859]

Wed, 13 October 2010 01:23

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Hi,

i am using Oracle 10.2.0.4 on win 2008 server SP2. I would like to know if we can set the Segment Space Management feature to AUTO for RBS and Temporary tablespaces. As the data is not permanent in these tablespaces, will it manage automatically?

Presently its Segment Space Mgmt is manual for System, RBS, Temporary tablespaces.

Please advice

Report message to a moderator

Re: need help with segment space management [message #478861 is a reply to message #478859]

Wed, 13 October 2010 01:32

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

It isn't possible to convert a tablespace to automatic segment space management.

Report message to a moderator

Re: need help with segment space management [message #478862 is a reply to message #478859]

Wed, 13 October 2010 01:41

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

Senior Member
Account Moderator

You do not choose segment or tablespace management for undo (I hope you use undo tablespace and not old rollback segments) and temporary, Oracle manages it as it is needed and best implemented (implementation which has nothing to do with your data tablespace management) you have not to care about that.

Regards
Michel

Report message to a moderator

Re: need help with segment space management [message #478868 is a reply to message #478862]

Wed, 13 October 2010 01:57

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Thanks guyz

Report message to a moderator

Re: need help with segment space management [message #478929 is a reply to message #478868]

Wed, 13 October 2010 12:24

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Restrictions on Automatic Segment-space Management
This clause is subject to the following restrictions:

You can specify this clause only for a permanent, locally managed tablespace.

You cannot specify this clause for the SYSTEM tablespace.

Report message to a moderator

Previous Topic:	PB to startup Oracle 7
Next Topic:	Can't create DB in Oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 01:14:39 CDT 2024