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

Thread: Solaris: rm: crmsa2_data01_01.dbf not removed: Permission denied

  1. #1
    Join Date
    Aug 2000
    Posts
    143

    Question

    Im trying to delete a file on solaris 2.6 and I get this error message
    rm: crmsa2_data01_01.dbf not removed: Permission denied

    I am the owner of the file but somehow the operating system does not allow me to delete this file.

    -rw-r----- 1 oracle dba 838862848 Oct 3 16:32 crmsa2_data01_01.dbf.

    Has anyone got any ideas why this is occuring?

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Is this file online? If it is online, then turn offline and dropped if you this is you want:

    alter database datafile 'entire_path' offline;

    Then in SO rm ...

    I think, but not sure now, you can do this too:

    alter database datafile 'entire_path' offline drop;

    Regards

    Angel

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    U can't drop the datafile.

    U can drop only a tablespace.

    aarroyob ?
    --------------------------
    The Time has come ....

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Do you have permission on the directory?
    Jeff Hunter

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Yes Vijay you have reason.

    Thanks for the correction

    Angel

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