I attempted to bring a tablespace back on line but I have encountered a problem. I get an error message stating "Error changing tablespace statusORA-01113: file 10 needs media recovery . . .
This datafile is not needed so I attempted to drop the datafile as follows: startup mount alter database datafile '/u02/oradata/MPDB/tie02.dbf' OFFLINE DROP; shutdown normal startup open; The tablespace still cannot come back on-line. Am I missing a step? Kevin B. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Bass INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
