Zombie DBF as top DB File ?
Hello,
I was pretty impressed to see in several of my ASH reports to see that my foremost Top DB file (accurating for 15%) was one DBF I dropped (using drop tablespace including ...) one week ago.
How can this be possible ?
Notice that this is a residual of a "migration" operation which consisted in renaming a schema and all its datafiles/tabpespaces. I operated it with classical DATAPUMP jobs (expdp/impdp).
If I run: select tablespace_name from dba_tablespaces where name = 'my zombie tablespace'; it just returns NOTHING (I did checked on schemas, datafiles and things like that just for sake of completeness).
I was pretty impressed to see in several of my ASH reports to see that my foremost Top DB file (accurating for 15%) was one DBF I dropped (using drop tablespace including ...) one week ago.
How can this be possible ?
Notice that this is a residual of a "migration" operation which consisted in renaming a schema and all its datafiles/tabpespaces. I operated it with classical DATAPUMP jobs (expdp/impdp).
If I run: select tablespace_name from dba_tablespaces where name = 'my zombie tablespace'; it just returns NOTHING (I did checked on schemas, datafiles and things like that just for sake of completeness).
0