DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: delete OS datafiles

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    I've dropped some tablespaces I didn't need any more. It worked fine in Oracle. When I tryied to delete unneeded datafiles from operating system directory it gives me an error saying 'cannot delete. file is being used by another process.'
    What could be the problem? How do I go about it?

  2. #2
    Join Date
    Nov 2000
    Posts
    205
    I am not sure if it is the same thing. But we dropped tablespaces once, and deleted the datafiles, and we could still not see the space recovered on the OS. Our sys admin suggested we restart the db and the space got recovered.

    Alternatively fuser (on unix ) shows who is using a certain file or process.

    Good luck
    nirasha

  3. #3
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    One of the oracle server processes must have opened that file and till the process ends it will keep the file pointer. The best way is to stop and start the application. Then you should see the space back in the filesystem.

    Baliga

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width