Re: Drop databasefile?

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Fri, 15 Oct 1999 09:22:58 -0400
Message-ID: <7u79s8$gfi$1@autumn.news.rcn.net>

You could allocate 8G file for the set up and after that resize it to smaller size by:
alter database datafile ... resize 4000m. Also consider dropping a tablespace that is less painful than doing the same with a datafile -- you can simply re-load apps data using exp/imp by recreating the tablespace with the same name on another file(s).

Good luck,
Eugene.

Joerg Lanzinger <joerg_at_lanzinger.de> wrote in message news:3807170E.3C6EEFB1_at_lanzinger.de...
> Hello *,
>
> one of my applications needed about 8GB tablespace for setup. For
> running it will only use 4 GB. Is there a possibility to detach some of
> those "unused" databasefiles?
>
> Thanks in advance,
> Joerg
Received on Fri Oct 15 1999 - 08:22:58 CDT