Oracle | DBMS_VECTOR_DATABASE

Oracle DBMS_VECTOR_DATABASE_ADMIN Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Provides procedures and functions for basic CRUD operations on internal vector metadata tables, annotations, index creation.

As the result of an ACCESSIBLE BY clause no demos of package functionality are possible.

AUTHID DEFINER

Constants

Name	Data Type	Value
Status String
CONST_STATUS_EMPTY	VARCHAR2(5	'Empty'
CONST_STATUS_ACTIVE	VARCHAR2(6	'Active'
CONST_STATUS_UPDATING	VARCHAR2(10)	'Updating'
Status Number
CONST_STATUS_EMPTY_NUM	NUMBER	0
CONST_STATUS_ACTIVE_NUM	NUMBER	1
CONST_STATUS_UPDATING_NUM	NUMBER	2
Exceptions
CONST_EXCEP_GENERAL_ERROR	NUMBER	-20412
EXCEP_ID_ALREADY_EXISTS_LOAD_VECTORS	NUMBER	-57717

Dependencies

ALL_INDEXES	DBMS_STANDARD	OBJ$
ALL_OBJECTS	DBMS_VECTOR_DATABASE	USER$
ALL_TABLES	JSON_ELEMENT_T	VECTOR_TABLE_METADATA
ALL_USERS	JSN_OBJECT_T

Documented No

Exceptions

Error Code	Reason
ORA-00942	Table or view does not exist
ORA-01031	Insufficient privileges
ORA-44002	Invalid SQL name

First Available 26ai

Security Model Owned by SYS with EXECUTE with no privileges granted

accessible by (package sys.dbms_vector_database)

Source {ORACLE_HOME}/rdbms/admin/dbmsvectordbadmin.sql

Subprograms

ADD_VECTOR_TABLE_METADATA	GET_VECTOR_SUMMARY
DELETE_VECTOR_TABLE_METADATA	GET_VECTOR_TABLE_METADATA
GET_DENSE_INDEX_FOR_VECTOR_TABLE	LIST_VECTOR_TABLE_METADATA
GET_EMBED_PARAMS	UPDATE_VECTOR_TABLE_METADATA

ADD_VECTOR_TABLE_METADATA (new 26ai)

Inserts a new vector table entry into the metadata table
SYS.VECTOR_TABLE_METADATA

Used for registering vector-capable tables along with their indexing and embedding parameters. dbms_vector_database_admin.add_vector_table_metadata( p_vector_table_name IN VARCHAR2, description IN VARCHAR2, vector_type IN VARCHAR2, embed_params IN JSON, index_params IN JSON, status IN NUMBER, vector_table_type IN VARCHAR2, current_user IN VARCHAR2);

TBD

DELETE_VECTOR_TABLE_METADATA (new 26ai)

Deletes an existing vector table entry from SYS.VECTOR_TABLE_METADATA. dbms_vector_database_admin.delete_vector_table_metadata( p_vector_table_name IN VARCHAR2, current_user IN VARCHAR2);

TBD

GET_DENSE_INDEX_FOR_VECTOR_TABLE (new 26ai)

Undocumented dbms_vector_database_admin.get_dense_index_for_vector_table( p_vector_table_name IN VARCHAR2, current_user IN VARCHAR2) RETURN CLOB;

TBD

(new 26ai)

Undocumented dbms_vector_database_admin.get_embed_params( p_vector_table_name IN VARCHAR2, current_user IN VARCHAR2) RETURN CLOB;

TBD

GET_VECTOR_SUMMARY (new 26ai)

Undocumented dbms_vector_database_admin.get_vector_summary(current_user IN VARCHAR2) RETURN CLOB;

TBD

GET_VECTOR_TABLE_METADATA (new 26ai)

Returns full metadata for a specific vector table belonging to the
current session user as a JSON object. dbms_vector_database_admin.get_vector_table_metadata( p_vector_table_name IN VARCHAR2, current_user IN VARCHAR2) RETURN CLOB;

TBD

LIST_VECTOR_TABLE_METADATA (new 26ai)

Returns all vector tables registered for the current session user as a JSON array format dbms_vector_database_admin.list_vector_table_metadata(current_user IN VARCHAR2) RETURN CLOB;

TBD

UPDATE_VECTOR_TABLE_METADATA (new 26ai)

Updates the description, annotations, status, and stats for an existing vector table entry in SYS.VECTOR_TABLE_METADATA. dbms_vector_database_admin.update_vector_table_metadata( p_vector_table_name IN VARCHAR2, description IN VARCHAR2 DEFAULT NULL, annotations IN JSON DEFAULT NULL, status IN NUMBER DEFAULT NULL, current_user IN VARCHAR2);

TBD