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: Teresa <tpreto7_at_sapo.pt>
Date: 11 Sep 2002 18:36:38 -0700
Message-ID: <6dabc692.0209111736.6b5492f3@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 Wed Sep 11 2002 - 20:36:38 CDT

Original text of this message

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