Re: decrease tablespace size

From: Nighr <nighr_at_aol.com>
Date: 1998/02/16
Message-ID: <19980216203500.PAA23009@ladder03.news.aol.com>#1/1

In article <34C4B95D.F340A984_at_compuserve.com>, Ulrich Waldt <KZVN_at_compuserve.com> writes:

>First I thought about an Export, but there is no way to export a
>tablespace.

No, but you will probably have to export all the objects in the table space. You'll have to make a report on the objects you want to export from the view DBA_OBJECTS. Drop the tablespace including objects, re-create the tablespace with the new size, then import. Of course back up your database before doing this!

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