| How reduce System Tablespace? [message #57094] |
Tue, 20 May 2003 08:04  |
Yazmin
Messages: 13
Registered: August 2002
|
Junior Member |
|
|
Hi I donīt speak english very well
My question is: How can I do to reduce size of Tablespace SYSTEM?
Thanks for your help
|
|
|
|
| Re: How reduce System Tablespace? [message #57103 is a reply to message #57094] |
Tue, 20 May 2003 15:46  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
Try this:
alter database datafile '[[your_system_datafile_name]]' resize [[new_size_in_bytes]];
Make sure to leave plenty of free space (~100 MB) because running out of space on the SYSTEM tablespace is VERY, VERY BAD.
HTH,
Andy
|
|
|
|
| Re: How reduce System Tablespace? [message #57120 is a reply to message #57103] |
Wed, 21 May 2003 10:31 |
Yazmin
Messages: 13
Registered: August 2002
|
Junior Member |
|
|
Thanks Andy
That already try it to do but says me that there are objects in the tablespace. The size is 31 GB!!! and canīt not reduce with the solution that your you propose.
It exists some another way to reduce the size without have to return to do the database?
Thank you very much
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
