Re: rollback tablespace datafile too big

From: Ewan Parker <ewan_at_chimera.u-net.com>
Date: 2000/07/29
Message-ID: <555.245T2297T495580ewan@chimera.u-net.com>#1/1

On 28-Jul-00 14:56:44, oratune said about Re: rollback tablespace datafile too big:

> Datafiles don't shrink when there is no data in them. Once you create a
> datafile you can't make it smaller without dropping the tablespace,
> deleting the datafile and then recreating the tablespace with a smaller
> datafile.

If the space at the end of a datafile is unused, it can be shrunk using 'alter database datafile ... resize ...'.

Ewan.

> --
> David Fitzjarrell
> Oracle Certified DBA

--
PGP footprint: 3A 82 19 D7 7A 61 D3 DC  4D F3 87 B2 27 99 BE 77

Received on Sat Jul 29 2000 - 00:00:00 CDT