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

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