Re: How to shrink a tablespace?

From: Pedro Bandeira <pbandei_at_calvanet.calvacom.fr>
Date: 1995/08/06
Message-ID: <402985$7gd_at_midgard.calvacom.fr>#1/1


mgraz_at_netcom.com (Michael Graz) wrote:
>Greetings -
>
>I have inherited an Oracle database that is taking up far too much disk
>space. I would like to shrink the tablespaces a bit. Any thoughts on
>the easiest/safest way to accomplish this?
>
>I'm guessing that I'll have to export a tablespace at a time, recreate
>it using less space, and then import the data. Is there a safe way to
>export everything in a single tablespace and then restore it?
>
>Thanks to any suggestions - Mike :)
>
>----------------
>Michael Graz
>mgraz_at_netcom.com
>----------------
>
>

Just export full your database, recreate it with smaller tablespaces, then reimport it. No sweat.

Pedro Received on Sun Aug 06 1995 - 00:00:00 CEST

Original text of this message