Re: datafile problem

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 12 Sep 2002 22:17:16 +1000
Message-ID: <Sr%f9.30325$g9.87962@newsfeeds.bigpond.com>

Hi Teresa,

I like your contribution here.

It's compact, direct, to the point, no waffle, accurate, no mentioning of rock legends and yet as informative as most of my efforts.

I'm learning ... ;)

Richard
"Teresa" <tpreto7_at_sapo.pt> wrote in message news:6dabc692.0209111736.6b5492f3_at_posting.google.com...

> ?

> > >
> > > If you have lots of free space in the tablespace, have you tried to
 downsize
> > > the datafile again?
> > >
> > > You can always create a new tablespace, move the tables to the new
> > > tablespace and then drop the old tablespace ...
> > >
> > > Best Regards
> > >
> > > "Helena" <hmatijaca_at_yahoo.ca> wrote in message
> > > news:c5a36d06.0208260634.47c52694_at_posting.google.com...
> > > > I have a production db in which I have incresed a tablesplace and
 the
> > > > datafile it shows at 99% full, but I do have lots of space on the
> > > > tablespace, How can I clean the datafiel to show empty?
> > > >
Received on Thu Sep 12 2002 - 07:17:16 CDT