Skip to Main Content

Live SQL

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!

Testing with VECTOR and VECTOR INDEX

user71116415 days ago

Hello All,

In database LiveSQL V2 I am trying to perform a few tests using VECTOR data type and a VECTOR index.

But, I encounter a quota error, even if I only try to insert a single row, as follows.

The following statements created the table and vector index successfully:

create table qz_vectors (
id integer primary key,
embedding vector(8, float32)
)
/

create vector index qz_vectors_ivf_cosine
on qz_vectors (embedding)
organization neighbor partitions
distance cosine
parameters (
type ivf,
neighbor partitions 42,
min_vectors_per_partition 0
)
/

We can see all the created objects below:


select table_name
from user_tables
where table_name like '%QZ_VECTORS%'
order by table_name
/
TABLE_NAME                                                                    
----------------------------------------------------------------------------- 
QZ_VECTORS                                                                    
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROIDS             
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS  

3 rows selected.

select table_name, column_name, data_type
from user_tab_cols
where table_name like '%QZ_VECTORS%'
order by table_name, column_name
/
TABLE_NAME                                                                    COLUMN_NAME        DATA_TYPE 
----------------------------------------------------------------------------- ------------------ --------- 
QZ_VECTORS                                                                    EMBEDDING          VECTOR    
QZ_VECTORS                                                                    ID                 NUMBER    
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROIDS             CENTROID_ID        NUMBER    
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROIDS             CENTROID_VECTOR    VECTOR    
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS   BASE_TABLE_ROWID   ROWID     
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS   CENTROID_ID        NUMBER    
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS   DATA_VECTOR        VECTOR    

7 rows selected.

select table_name, partition_name
from user_tab_partitions
where table_name like '%QZ_VECTORS%'
order by table_name, partition_name
/
TABLE_NAME                                                                    PARTITION_NAME 
----------------------------------------------------------------------------- -------------- 
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS   P1   
         
1 rows selected.


select table_name, index_name, index_type
from user_indexes
where table_name like '%QZ_VECTORS%'
order by table_name, index_name
/
TABLE_NAME                                                                    INDEX_NAME                 INDEX_TYPE 
----------------------------------------------------------------------------- -------------------------- ---------- 
QZ_VECTORS                                                                    QZ_VECTORS_IVF_COSINE      VECTOR     
QZ_VECTORS                                                                    SYS_C004128216             NORMAL     
QZ_VECTORS                                                                    SYS_IL0004038857C00002$$   LOB        
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROIDS             SYS_C004133187             NORMAL     
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROIDS             SYS_IL0004043444C00002$$   LOB        
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS   SYS_C004133189             NORMAL     
VECTOR$QZ_VECTORS_IVF_COSINE$4038857_4043443_0$IVF_FLAT_CENTROID_PARTITIONS   SYS_IL0004043448C00003$$   LOB   
     
7 rows selected.

However, the following attempt to insert a single row fails:

insert into qz_vectors(id, embedding)
values ( 1, to_vector( '[1,2,3,4,5,6,7,8]' ) )
/

ORA-01536: space quota exceeded for tablespace 'USERS'

Another problem, also related to testing with VECTOR-s:

The dictionary table VECSYS.VECTOR$INDEX cannot be accessed, probably due to missing privileges:

select * from VECSYS.VECTOR$INDEX
where idx_name like '%QZ_VECTORS%'
/

ORA-00942: table or view "VECSYS"."VECTOR$INDEX" does not exist

Thanks a lot in advance for looking into this problem and correcting it
so that at least some tests using a reasonably small data set could be performed using this environment.

Best Regards,
Iudith Mentzel

This post has been answered by Layla Elwakhi-Oracle on Oct 7 2025
Jump to Answer
Comments
Post Details
Added 5 days ago
2 comments
37 views