Re: Is it possible to reduce the datafile size?

From: Noah Monsey <noah_at_indirect.com>
Date: 1996/06/23
Message-ID: <31cd0727.3110677_at_165.247.1.4>#1/1

kittu_at_gis.eng.hawaii.edu (Chakravarthy Nalamotu) wrote:

>Hi Oracle Users,
>Is it possible to reduce the datafile size
>with/without losing data. I have a datafile,
>using 10% of the space. Was wondering if I
>can rip off some of that un-used space.
>Atleast, at this point I do not intend to drop the
>tablespace though.
>
>Thank you for your replies,
> Kittu.
>

An easy way to restructure your tablespaces is to recreate the database. I would recommend exporting the data, Then recreating Oracle database with the correct tablespace sizes.

The way I usually do it is to get the crdb2 file from the $ORACLE_HOME/dbs directory. You should be able to edit the crdb and crdb2 scripts to change the file sizes and locations pretty easily. The import the data from the old database. ========= ========= ========= ========= =========

Noah Monsey                       noah_at_indirect.com

========= ========= ========= ========= ========= The only dumb question is the one that you don't ask. ========= ========= ========= ========= ========= Oracle Master Database Administration, April 1992 Oracle Master Application Development, April 1992 ========= ========= ========= ========= ========= Received on Sun Jun 23 1996 - 00:00:00 CEST