ORA-51909
Creating vector index owner_name.index_name is failing because col_type distance is attempted on string format.
- owner_name: The owner of the index.
- index_name: The index name.
- col_type: The column type.
Cause
Creating a vector index is failing since vector indexes that use HAMMING or JACCARD distance can only be created on vectors with INT8 or BINARY format.
Action
Use a distance metric other than HAMMING or JACCARD distance, or ensure all vectors are of INT8 or BINARY format.