Re: rollback tablespace datafile too big

I thought the only restriction was you cannot shrink a datafile to where there's data. In other words, if you create a tablespace with 100M datafile, create some small tables in there, you can still resize the datafile to, say, 50M.

Yong Huang

<oratune_at_aol.com> wrote in message news:8ls6v8$il0$1_at_nnrp1.deja.com...
> In article <8ls0j2$df9$1_at_nnrp1.deja.com>,
> fly13_at_my-deja.com wrote:
> > Hi
> > Here is a n easy question about RBS tablespace on Oracle 8.1.6.
> > I had big transaction to do on a table.
> > And so my RBS datafile (rbs1.dbf) is very big.
> > The problem is when there is no transaction any more, and the commit
> > has been done, the size of the RBS datafile is still the same.
> > I try to coalesce this tablespace, but no result.
> > Can someone help me to reduce the size of this file?
> >
> > Cheers in advance!!!
> >
> > Fly13
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> 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.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT