just to clarify... this database was just handed down to me. i've been working with this database for the past week. i dont know what the former dba did to this database!

anyway, ERICDATA is the datafile used. the file is physically visible in the OS. i know its screwed up, just hoping that we can retrieve the data in the said datafile. i was thinking of dropping the tablespace and recreate it just so the application using it will run. am i thinking it right?

thanks!