Home » RDBMS Server » Server Administration » Drop tablespace can't delete datafile (Oracle10gR2, RHEL5)
Drop tablespace can't delete datafile [message #332638] Wed, 09 July 2008 04:42 Go to next message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

Dear all,

Recently I tried to drop the tablespace but can't drop some of its datafiles.
drop tablespace TS200802 including contents and datafiles
Tue Jul  1 15:26:24 2008
WARNING: Cannot delete file /disk1/data/data_D-TESTS_I-1480994533_TS-TS200802_FNO-18_73jb2vi9
ORA-01265: Unable to delete DATA /disk1/data/data_D-TESTS_I-1480994533_TS-TS200802_FNO-18_73jb2vi9
ORA-27056: could not delete file
Linux-x86_64 Error: 13: Permission denied
Tue Jul  1 15:26:35 2008
Deleted file /disk8/TS200802/data_D-TESTS_I-1480994533_TS-TS200802_FNO-86_6kjb2n41
Tue Jul  1 15:26:46 2008
Deleted file /disk8/TS200802/data_D-TESTS_I-1480994533_TS-TS200802_FNO-87_6ljb2nns
Tue Jul  1 15:26:57 2008
Completed: drop tablespace TS200802 including contents and datafiles


Then I manually drop the datafile it still prints the following error.

rm: cannot remove `/disk1/data/data_D-TESTS_I-1480994533_TS-TS200802_FNO-18_73jb2vi9': Permission denied


ls -lh 
-rw-r----- 1 oracle oinstall 8.1G Mar 12 11:00 /disk1/data/data_D-TESTS_I-1480994533_TS-TS200802_FNO-18_73jb2vi9


What does this error mean?

Please help, thanks
Re: Drop tablespace can't delete datafile [message #332646 is a reply to message #332638] Wed, 09 July 2008 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64129
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See permission on directory.

Regards
Michel
Re: Drop tablespace can't delete datafile [message #332698 is a reply to message #332638] Wed, 09 July 2008 06:55 Go to previous message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

Thank you very much Michel
Previous Topic: How to enable/On recyclebin in 10g db
Next Topic: Need to move a new datafile from one tablespace to another tablespace
Goto Forum:
  


Current Time: Wed Dec 07 06:49:28 CST 2016

Total time taken to generate the page: 0.17254 seconds