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?
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
U can't drop the datafile.
U can drop only a tablespace.
aarroyob ?
Do you have permission on the directory?
Yes Vijay you have reason.
Thanks for the correction
Angel