Commands were issued to drop tablespaces. However, the including contents etc was not a part of the statement. It was intentionally done to prevent dropping datafiles that contain data. Now the datafiles need to be removed. This doesn't appear to be a common issue. Does anyone know how I can identify and remove the files? We are using ASM. I can see 2 files that are associated with dropped tablespaces. However, understandably I can't see the datafiles by querying the database. It is unclear how I can query within asm to find the datafiles. Is there a script out there that can somehow query and get a list of files with no associated tablespace and remove them?