Re: dowsizing tablespace system

Hector,

Export e Import no te sirven para tablespaces, solo para schemas como tables.

Yo he reducido espacio no usado en tablespaces que no son del system con el commando:

ALTER TABLESPACE <TU TABLESPACE NAME> COALESCE;

pero antes reduci varias de las TABLES con ALTER TABLE ......... DEALLOCATE....; Ahora, nunca lo he hecho con tablespaces del SYSTEM.

Quiza, si tienes una instance para pruebas, puedas tratar ahi primero.

Regards,

1. Fuentes 512-297-9937

<hjuarez_at_tamsa.com.mx> wrote in message news:aiv09b$ir7$1_at_news.netmar.com...
>
>
> 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
eb -----
> 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 Received on Fri Aug 09 2002 - 08:47:58 CDT