Re: [Q] Can you shrink tablespaces?

From: Przemys³aw Pakulski <przemop_at_talex.com.pl>
Date: Thu, 13 Aug 1998 09:04:22 +0200
Message-ID: <6qu36d$r25$1@sunflower.man.poznan.pl>

Chris Muir napisa³(a) w wiadomoœci: <35d27df8.155785938_at_mitswa>...
>Howdy.
>
>I currently have a tablespace that is 30% percent full. The data in
>the tablespace is static and wont change or grow. Is there a way to
>shrink the tablespace size to obtain the disk space back?
>

You can try following:

ALTER TABLESPACE tablespace DATAFILE datafile RESIZE xxM

where xx is the new size of datafile in MB.

Przemo Pakulski
przemop_at_talex.com.pl Received on Thu Aug 13 1998 - 02:04:22 CDT

This message: [ Message body ]
Next message: Vaughan Mc Carthy: "Re: How do I use views in a stored procedure?"
Previous message: Maija-Leena Kangasmäki: "ora-1403 when generating replication support"
In reply to: Chris Muir: "[Q] Can you shrink tablespaces?"
Next in thread: Oracleguru: "Re: [Q] Can you shrink tablespaces?"
Reply: Oracleguru: "Re: [Q] Can you shrink tablespaces?"
Reply: poohland_at_hotmail.com: "Re: [Q] Can you shrink tablespaces?"
Reply: RP DATA SOLUTIONS: "Re: [Q] Can you shrink tablespaces?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US