My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.