problems with dba_free_space and stuff

I have recently added a second raw tablespace to hold indexes. At the same time I expanded a temporary tablespace with a 100MB file system file. No I have two problems: (that I can't explain :->)

 A select from dba_free_space returns an internal oracle error (sorry,    can't remember it now. I can get it tho)  My other temporary tablespace is invisible to the RDBMS. (i.e. an attempt  to alter user temporary tablespace TMP_SPACE_2 says TMP_SPACE_2 DNE, however,  is certainly see it with select * from dba_tablespaces)

Are these harbingers of really bad things happening at a very low level? If so, what to do? (Please don't say full export and rebuild!!!!)

TIA alan johnson
(johnsona_at_ashley.cofc.edu) Received on Thu Sep 30 1993 - 13:28:36 CET