How do I know if a tablespace/dbf is in use
914444Mar 1 2012 — edited Mar 7 2012I am planning to move some database files from one drive to another due to space issue. Since it is a prod environment, i cant make the dbf/tablespace offline just like that and move to a different path. So it would be helpful if i know which tablespace/dbf is not in use so that i can move that without affecting the environment. Please suggest.