Re: datafile problem

From: Eduardo Tavares <ejtavares_at_tmn.pt>
Date: Mon, 26 Aug 2002 16:19:40 +0100
Message-ID: <jGra9.629$BV7.1738773@newsserver.ip.pt>

Where does it show 99% full ?

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 Mon Aug 26 2002 - 10:19:40 CDT