How to fix the Oracle error ORA-39273: Cannot alter storage type of XMLType column: string?

In this post, you’ll learn more about the Oracle ErrorORA-39273: Cannot alter storage type of XMLType column: string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39273: Cannot alter storage type of XMLType column: string

Reason for the Error ORA-39273: Cannot alter storage type of XMLType column: string

DBMS_METADATA_DIFF was comparing two XMLType columns with different storage types (CLOB, BINARY, OBJECT RELATIONAL). There is no SQL ALTER statement to change the storage type of an XMLType column.

How to fix the Error ORA-39273: Cannot alter storage type of XMLType column: string ?

You can fix this error in Oracle by following the below steps

The difference cannot be eliminated with an SQL ALTER statement.