| reorganization a sys table [message #60183] |
Wed, 21 January 2004 11:05  |
Henry Rojas
Messages: 6
Registered: January 2004
|
Junior Member |
|
|
Hi Gurus
I need reorganization a table sys (sys.c_ts#) because I need free space in a system tablespace (size 8GB and only uses 500 MB) and this table was created at the end of tablespace. what ca I do?
thanks
|
|
|
|
| Re: reorganization a sys table [message #60185 is a reply to message #60183] |
Wed, 21 January 2004 16:17  |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
Hi....
It seems that table has information related to tablespaces..i think you could not even move it to another tablespace.
Is there any posibility to you to recreate the entire database?
Best luck
|
|
|
|
| Re: reorganization a sys table [message #60192 is a reply to message #60183] |
Thu, 22 January 2004 09:04 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi,
which segments in SYSTEM tablespace consume the most space ? Did you use SYSTEM for temp/undo segments accidentally ?
There's no documented/supported procedure for rebuilding sys objects(other than sys.AUD$) directly. Recreating the database is certainly an option,if its viable.
Do you have Oracle support ?
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
