Hi All,
I ran into some sort of problem that I cannot find an explanation for. THe scenario is this:

I added a new datafile to a tablespace and did some test/practice and afterwards I removed it from the database and also from the physical disk.

The problem is this: When I do a query on the v$datafile, the name is still listed.

Is this because the datafile name is/was listed in the controlfile? What do I do to remove it from showing up when I query the v$datafile?

Thanks in advance,
Dee.