6 likes
·
784 reads
8 comments
Hi Jon, great post - as always. Maybe the REGEXP could be replaced by CONVERT, converting the text into a non-multibyte characterset...
Thank you Martin, I will give that a try.
Hi Jon, congrats! This is the perfect article for people wanting to get started with vector search. Well done.
Cheers Dimitri.
Hi! I am eager to give it a try, but I cannot get to import the model with the DATA_PUMP part. I have an Always Free in UK, loaded the model in a private bucket - that I can successfully verify using SELECT * FROM DBMS_CLOUD.LIST_OBJECTS(), but get "ORA-20000: ORA-29283: invalid file operation: nonexistent file or path [29434]" at DBMS_CLOUD.GET_OBJECT(). Can you point me to the right direction? Thank you!
Hi. Did you grant read on the data pump directory to your scheme? GRANT READ ON DIRECTORY DATA_PUMP_DIR TO YOUR_SCHEMA;
Jon Dixon Hi! it seems that OCI has some loose ends. May be its my 2019 free tier account, or that it also has an 19c DB... The issue with DATA_PUMP_DIR seems related to resource principal: in 19c I am able to do a dpexp, but it fails on 23ai... Anyway, went to the basics: read the docs... and found DBMS_VECTOR.LOAD_ONNX_MODEL_CLOUD(), that goes directly to the object store-one step only. Now, on track... Thank you.
there is no error with sql developer