Re: Resizing tablespace

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 28 Sep 2004 22:31:26 +0200
Message-ID: <cfijl0984h3e44hpqnvj0e41vqr9c7an84@4ax.com>

On 28 Sep 2004 13:23:11 -0700, madcap_at_email.com (madcap) wrote:

>Hi folks,
>
>I am using Oracle 9i with LMT. However one of the tablespace, USERS,
>is sized on a higher side and is 20% used. Can I not simply export
>all the objects that belong in that tablespace, drop objects, resize
>the tablespace and re-import?
>
>Is there anything wrong in the above method? The data is not much.
>
>Thanks in advance.

should work.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Sep 28 2004 - 15:31:26 CDT