Re: Resizing tablespace

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Tue, 28 Sep 2004 21:29:01 GMT
Message-ID: <xIk6d.170$Nf4.84@newsfe4-gui.ntli.net>

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:cfijl0984h3e44hpqnvj0e41vqr9c7an84_at_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

umm why not just resize it downwards? Received on Tue Sep 28 2004 - 16:29:01 CDT