Q
Manage Learn to apply best practices and optimize your operations.

How to avoid Oracle error ORA-00060 when dropping a datafile in Oracle 10g

Learn how to avoid an Oracle error, ORA-00060, when dropping a datafile in Oracle 10g with this tip from an Oracle expert.

I'm trying to drop a broken datafile in my Oracle 10g using this:

ALTER TABLESPACE "TABLESPACE" DROP DATAFILE '/sata/oracle/db_1/oradata/ORCLM7/spacefiles/spacefiles_8'

But I always get the following error: ORA-00060: deadlock detected while waiting for resource

I drop all tables/packages which belong to this datafile. This datafile is on offline mode. Can you help?

I have never dropped a datafile without dropping the tablespace. Instead, what I do is to create a new tablespace, then move any tables/indexes to the new tablespace and finish it by dropping the old tablespace in its entirety.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close