Datafile has been removed already , But I still can find its information in V$datafil

[ligang]

Datafile has been removed already , But I still can find its information in V$datafile
why?

[jovery]

Unless you offline and remove the datafile with a drop command the entry will remain in the data dictionary. Simply removing the datafile will not remove it association with the Oracle database.

Regards

[sandycrab]

would you please tell us how did you remove the datafile...means using what command??

[prakashs43]

as per my knowledge .
once created datafile cannot be dropped through normal sql syntax . tablespace associated with the datafile can be dropped, which removes the datafile from v$datafile.

[soniaarora]

alter database datafile 'xxx' offline drop;

Or if it is the only datafile in the tablespace,
Drop tablespace name including contents;

[pando]

offlince drop a datafile will force you to drop entire tablespace

[soniaarora]

Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.

[prakashs43]

after droping the datafile . i believe we cannot make it online
with a similar syntax . only option it leaves is to recover the database if it is in archivelog mode .
is this syntax valid prior to version 8 .

[soniaarora]

I think we moved from the actual question posed. The one line reply is:

"References to the dropped datafiles are not eliminated from views unless the tablespace in which they exist is recreated or dropped. "

[pando]

Originally posted by soniaarora
Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.

may?

no, you are forced to, you cant never ever remove a datafile from a tablespace