OraFAQ Forum: Server Administration » Segment Space Management

Home » RDBMS Server » Server Administration » Segment Space Management - Tablespace

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

Segment Space Management - Tablespace [message #207451]

Tue, 05 December 2006 11:16

prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai

Member

Hi all,

Is it possible to change the segment space management of the tablespace(SYSTEM AND OTHER TBS) from MANUAL TO AUTO after it was created.

If so what is the proper syntax to execute the same.

DB: Oracle10g
OS: Sun solaris 5.6

Regards,
Prashanth

Report message to a moderator

Re: Segment Space Management - Tablespace [message #207455 is a reply to message #207451]

Tue, 05 December 2006 11:25

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quote:

The segment space management that you specify at tablespace creation time applies to all segments subsequently created in the tablespace. You cannot change the segment space management mode of a tablespace.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1154

Report message to a moderator

Re: Segment Space Management - Tablespace [message #207532 is a reply to message #207455]

Tue, 05 December 2006 22:48

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi Prashanth,

You can create another tablespace with segment space management auto & move tables of tablespace with segment space management manual into that tablespace.
After which you have to rebuild index of each table.
This is possible in Oracle 9i.
No idea about oracle 10g.

[Updated on: Tue, 05 December 2006 22:55]

Report message to a moderator

Re: Segment Space Management - Tablespace [message #207578 is a reply to message #207532]

Wed, 06 December 2006 02:16

bwetkstr
Messages: 114
Registered: August 2005

Senior Member

seema.taunk wrote on Wed, 06 December 2006 05:48

Ok but should you been doing this for the system tablespace? I don't think that is a good idea. Don't forget the information of your tables, indexes, ... are stored in the sys tables. SO if you move the tables, the indexes become invalid, ... god know what consequences this could cause !

Kr
Karel

[Updated on: Wed, 06 December 2006 02:18]

Report message to a moderator

Re: Segment Space Management - Tablespace [message #207607 is a reply to message #207578]

Wed, 06 December 2006 03:40

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

I have replied for non system tablespace.
Sorry forgot to mention abt system tablespace.

Report message to a moderator

Re: Segment Space Management - Tablespace [message #207629 is a reply to message #207451]

Wed, 06 December 2006 05:26

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

When You create Locally managed tablespace in Oracle 10g the default space management is "AUTO".

YOu can also apply some procedure. suggested by "seema" in 10g.

regards
Taj

[Updated on: Wed, 06 December 2006 05:36]

Report message to a moderator

Previous Topic:	Oracle XDK is INVALID
Next Topic:	TRUNCATE COMMAND

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:27:49 CDT 2024