Re: Reduce tablespace physical file size

Alon Barnes wrote:

>I'm encountering a strange problem in one of my tablespaces in the
>database.
>
>One of my oracle tablespaces (that is represented as a phisical DBF
>file) is with size of 4GB. Several checks I made showed that there is
>no table or index in this tablespace.
>
>BUT - when I try to reduce the size of the file with this command:
>
>alter database datafile 'TS.DBF' resize 2000M;
>
>I get an error message:
>
>ORA-03297: file contains 96350 blocks of data beyond requested RESIZE
>value
>
>which means that the tablespace IS containing something (someone told
>me that there might be system data in it).
>
>Does anyone have an idea how to handle this? How can I reduce the size
>of this TS? what is the data kept in it?
>
>Thanks a lot,
>Alon
>
>

Follow Howard's advice checking DBA_SEGMENTS to make sure nothing is really there.

If nothing is there then why reduce its size? Just take it off-line, drop it, and recreate what you want.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)