Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafile problem

Re: datafile problem

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 26 Aug 2002 15:38:43 +0100
Message-ID: <U3ra9.11477$zX3.19308@news.indigo.ie>


One presumes that an undesirable answer is "Drop all the tables in it. " (this is an answer portable between versions of Oracle tho.)

however, pls post version of Oracle; there are different possible answers.

"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 - 09:38:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US