How to fix the Oracle error DRG-10528: primary keys of type string are not allowed?

In this post, you’ll learn more about the Oracle ErrorDRG-10528: primary keys of type string are not allowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10528: primary keys of type string are not allowed

Reason for the Error DRG-10528: primary keys of type string are not allowed

Cause: you tried to create an index on a table with an illegal primary key datatype

How to fix the Error DRG-10528: primary keys of type string are not allowed ?

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

Action: change the textkey to one of the followings: VARCHAR2, NUMBER, VARCHAR, DATE, CHAR, MLSLABEL