Re: Resizing tablespace

From: <sybrandb_at_yahoo.com>
Date: 29 Sep 2004 07:45:13 -0700
Message-ID: <a1d154f4.0409290645.425793ff@posting.google.com>

"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:<xIk6d.170$Nf4.84_at_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?

Because there might be segments at the end of the tablespace, causing a resize to fail!

Sybrand Bakker
Senior Oracle DBA Received on Wed Sep 29 2004 - 09:45:13 CDT