Skip to Main Content

FreeSQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot create tables with sparse vectors in LiveSQL

Anthony HarperOct 12 2025

Trying to create a table with sparse vectors in live SQL fails with a compatibility setting error:

SQL> create table vector_coordinate (
notes varchar2(30),
v_sparse vector(4,int8,sparse),
v_dense vector(4,int8,dense)

)

/

ORA-00406: COMPATIBLE parameter needs to be 23.6.0.0.0 or greater
ORA-00722: Feature "SQL VECTOR SPARSE format"

This post has been answered by thatJeffSmith-Oracle on Oct 29 2025
Jump to Answer
Comments
Post Details
Added on Oct 12 2025
1 comment
48 views