ORA-01753: column definition incompatible with clustered column definition

<<Back to DB Administration Main Page

ORA-01753: column definition incompatible with clustered column definition

SQL > CREATE TABLE employees ( department_id number(3), name varchar2(20))
  2  CLUSTER employees_departments_cluster (department_id);
CLUSTER employees_departments_cluster (department_id)
                                       *
ERROR at line 2:
ORA-01753: column definition incompatible with clustered column definition

Solution:

Verify and correct the cluster column definition in create table clause. To find the cluster key column 

length use below query

SQL> select DATA_PRECISION from dba_tab_columns  where owner='TEST' and TABLE_NAME='EMPLOYEES_DEPARTMENTS_CLUSTER';

SQL>  select  DATA_PRECISION from user_tab_columns  where  TABLE_NAME='EMPLOYEES_DEPARTMENTS_CLUSTER1';

 DATA_PRECISION
-------------- --------------
                            4

1 row selected.

SQL > CREATE TABLE employees ( department_id number(4), name varchar2(20))
  CLUSTER employees_departments_cluster (department_id);