OraFAQ Forum: Server Administration » Drop tablespace can't delete datafile

Home » RDBMS Server » Server Administration » Drop tablespace can't delete datafile (Oracle10gR2, RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop tablespace can't delete datafile [message #332638]

Wed, 09 July 2008 04:42

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

Report message to a moderator

Re: Drop tablespace can't delete datafile [message #332646 is a reply to message #332638]

Wed, 09 July 2008 04:57

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

See permission on directory.

Regards
Michel

Report message to a moderator

Re: Drop tablespace can't delete datafile [message #332698 is a reply to message #332638]

Wed, 09 July 2008 06:55

bbmonster
Messages: 47
Registered: June 2007
Location: UB

Member

Thank you very much Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 22 14:51:17 CDT 2024