SMON process et al are not letting go of datafiles when I place them offline

I have been running into a problem lately. For one reason or another (possibly to make a datafile backup so that I can later rename the datafile name in oracle), I wish to place a tablespace offline and do something to the datafiles but I get an access error. On my openvms system, I will check to see who still has access to the datafiles and I will notice that most of the time SMON (sometimes another standard oracle process) still has the datafile open for access. I was under the impression that placing a tablespace offline would cause the oracle processes to relinquish control over the datafiles. Am I not correct in assuming this and if I am not correct, why would these processes still want or need access to the datafile. Is there a better way bring the tablespace offline so that I can get access to the datafiles?

Matt Heiman
boo_at_deltanet.com Received on Sat Jun 13 1998 - 00:00:00 CDT