Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile problem
this is oracle v 8.1.7.0 on a Sun server,
I just increased the datafile, I beleive that what happen was that a
user created a tablespace and not pointed to the a new datafile, then
he came across the problem were the original datafile shows as @ 99%
on a GUI interface of OEM, this is a production server, therefore I
did not have much time, I just increased the size.
Thanks
Helena
"Eduardo Tavares" <ejtavares_at_tmn.pt> wrote in message news:<jGra9.629$BV7.1738773_at_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 - 18:03:14 CDT