Re: Deleting obsolete datafiles

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 22 Nov 2003 13:13:44 GMT
Message-ID: <ciJvb.22277$aT.16658@news-server.bigpond.net.au>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3FB8C6FE.2905_at_yahoo.com...
> Howard J. Rogers wrote:
> >
> > "Dennis Bieling" <dennis.bieling_at_epigenomics.com> wrote in message
> > news:bp2n5o$8q8$3_at_broglie.epigenomics.epi...
> > >
> > > To me this is much more easy, as there is no extent in
> > > the datafile already, so I set it to the smallest possible
> > > size, which was 16K in this example. So there is not enough
> > > space for oracle to create an extent in it and therefore it is kind of
> > > unusable.
> > >
> >
> > Still gets checkpointed, though.
> >
> > Regards
> > HJR
>
> The solution in this case is to add more and more datafiles, thus the
> overhead of checkpointing the obsolete one becomes a smaller and smaller
> percentage of that overhead :-)

Hi Connor,

If only your mind could be turned away from evil and be made to tread the path of goodness, perhaps there could be a chance for us all.

Cheers ;)

Richard Received on Sat Nov 22 2003 - 07:13:44 CST