Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems of new datafiles!!!!
Hello,
DBA_FREE_SPACE contains information on free space, possibly
your datafile is full.
You say you delete the objects on this tablespace: How?
If you use truncate to delete the rows the extents are still
in use.
You may check the space used on this datafile using the DBA_EXTENTS view.
Pep.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 14 1999 - 09:01:37 CST