ORA-04020 Deadlock Error While Moving Table/lob Object To Different Tablespace
(Doc ID 2973267.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Encountering deadlocks in application and from the application logs, SELECT statements and DMLs are failing with the below error.
"ORA-04020: deadlock detected while trying to lock object"
In this case, the error was observed while trying to move the lob columns on this table like below.
alter table "<schema_name>"."<table_name>" move lob("<lob1>") store as (tablespace <TS1>) ONLINE parallel 8;
Error stack will be like below.
Changes
na
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |