Dear gurus ! I have an "offline dropped" datafile at my database. The file was physically deleted at the OS level after "offline drop". Before dropping the file , all the objects that had extents allocated in that file (from dba_extents) were dropped. Now , V$datafile shows this file as of size=0 and status = 'RECOVER' which is fine. BUT , file$ show this file as of size 8GB, which is the file size as it used to be before being dropped. Moreover , fet$ shows 8GB as free extents residing at this file . And , after all , tables get created in that file , i.e. dba_extents show extents with FILE_ID of that file ! When a select statement tries to access a table with extents residing in that file , i get an error message , off course.
So , the question is , how do i make the file's extents disappear from fet$ ? Thanks a lot. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
