How do I find out if my datafile is being used and by what process. I need to perform certain task on my datafile and am getting error 'file in use'.
thank you.
Printable View
How do I find out if my datafile is being used and by what process. I need to perform certain task on my datafile and am getting error 'file in use'.
thank you.
Hi,
If the file is in use it should see the details in v$session and v$session_wait.
Baliga
You should take your tablespaces offline before you do anything with the datafiles.