| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> dropped datafile problem
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: andreyb_at_elrontelesoft.com
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: ListGuru_at_fatcity.com (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). Received on Mon Jan 21 2002 - 09:15:54 CST
 |
 |