Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile problem
?
> >
> > 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
![]() |
![]() |