Re: decrease tablespace size

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: 1998/02/16
Message-ID: <34E87C0E.74D7@ictgroup.com>#1/1

Hi Ulrich,

Why not just export the tables in the tablespace, resize it, and then reload?

Regards

Jerry

Ulrich Waldt wrote:
>
> Hello everybody,
>
> I need a little help with my tablspaces.
>
> What are the steps to decrease the amount of space for a tablespace?
> There are still data in the tablespace.
> First I thought about an Export, but there is no way to export a
> tablespace.
> We are running Oracle 7.1.6.2 on a unixsystem.
>
> Thanks for any help.
>
> Ulrich Waldt

-- 
Jerry Gitomer               Since I know how to spell DBA I is one!
jgitomer_at_ictgroup.com
jgitomer_at_p3.net             Opinions are mine not those of ICT Group

Received on Mon Feb 16 1998 - 00:00:00 CST