Vector Table

Create a vector table to store the records that you want to search.

Oracle VecDB supports integrated embedding vector tables and bring-your-own-vector tables.

Integrated Embedding Vector Tables

Use an integrated embedding vector table when Oracle AI Database should generate vectors automatically:

• Load an ONNX embedding model.
• Create a vector table and select the loaded embedding model.
• Specify embed_metadata_jsonpath to identify the metadata field that contains the content to embed.
• Upsert records that contain the selected metadata field. Oracle AI Database generates and stores the embedding.

Bring-Your-Own-Vector Tables

Use a bring-your-own-vector table when you generate embeddings outside Oracle AI Database or require full control of the embedding pipeline:

• Create a vector table with a dense vector type.
• Generate vectors with an external embedding model.
• Upsert records that include vector values and optional metadata filters.

Parent topic: How Oracle VecDB Works