ORA-01753: column definition incompatible with clustered ... - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 13, 2023 6:54:49 PM ● Video Link: https://www.youtube.com/watch?v=vpZuvtyr3T4

Duration: 2:05

5 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-01753: column definition incompatible with clustered column definition
Cause: An attempt was made to create a table in a cluster and one of the table's
clustered columns is not compatible with the corresponding cluster key column.
Action: Make sure that all table columns specified in the CLUSTER clause of the
CREATE TABLE statement are compatible with the corresponding columns of the
cluster key, as documented. For example, the data type and the declared collation of
a clustered table column must be the same as those of the corresponding cluster key
column.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database