Home » RDBMS Server » Server Administration » Segment Space Management - Tablespace
Segment Space Management - Tablespace [message #207451] Tue, 05 December 2006 11:16 Go to next message
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
Re: Segment Space Management - Tablespace [message #207455 is a reply to message #207451] Tue, 05 December 2006 11:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: Segment Space Management - Tablespace [message #207532 is a reply to message #207455] Tue, 05 December 2006 22:48 Go to previous messageGo to next message
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 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
seema.taunk wrote on Wed, 06 December 2006 05:48
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.




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 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,

I have replied for non system tablespace.
Sorry forgot to mention abt system tablespace.
Re: Segment Space Management - Tablespace [message #207629 is a reply to message #207451] Wed, 06 December 2006 05:26 Go to previous message
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:
  


Current Time: Mon Dec 05 09:08:15 CST 2016

Total time taken to generate the page: 0.09713 seconds