I realise that an OS level lock is put on the data files themselves while they are in use, however I was wondering if there are any conditions in which a database is not offline/detached in which these files can be moved or deleted?
The reasoning behind this is whether it is a safe enough assumption to assume that you don't need to worry about deleting a live database at the file level due to the implied lock.
Thanks!