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

[Shestakov]

Originally posted by nagarjuna
[mmm...v$datafile is a controlfile view...
[/B]

Oracle use v$datafile (control flie) mostly in ALTER DATABASE OPEN(MOUNT) process.
In most others situations oracle will use sys.ts$ and sys.file$ tables.
but records about datafile still present in dictioany tables and don't present in controlfile!!!
Very interesting situation...

THIS IS WRONG WAY.

[Edited by Shestakov on 09-07-2002 at 12:27 PM]