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