Select AI and Vector Search on a Legacy Oracle Schema: What It Actually Takes

Who this is for: DBAs and developers sitting on an Oracle schema that’s been in production for a decade or more, who keep hearing that Select AI and vector search are easy to bolt on, and want to know what that actually looks like before they try it on something that matters. I spent a Saturday morning trying to get Select AI to answer a simple question against our support ticket schema: “which customers filed more than three tickets about login failures in the last quarter.” The table names were fine ( TICKETS, CUSTOMERS, TICKET_CATEGORY ), but the columns were a different story. CUST_ID , CU