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
|
|
|
|
|
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 | 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
|
|
|
|
|