Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dowsizing tablespace system
Hi Hjuarez,
If you want to reclaim SYSTEM TS space below the data files HWM, you have one choice.
Full database export, create new database, full database import.
Go on, it'll be fun :)
Richard
hjuarez_at_tamsa.com.mx wrote:
>
> Hi,
>
> Any idea about how can I downsize tablespace SYSTEM?.
>
> I'm wasting a lot of space and can't resize smaller becouse the highwater
> mark.
>
> I know I can't export e import SYSTEM like any other tablespace and a wish no
> to rebuild the database.
>
> Thanks in advance.
>
> Regards,
>
> Héctor J. M.
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net