Reduce tablespace physical file size

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 Received on Sun Oct 19 2003 - 07:14:51 CDT