Yes there is a limitation on the amount of stored data. It's Free after all. But for testing and for most applications they may never reach the limit. The data can be compressed, which means you can store multiples of the allowed limit.

Yes you will need an API key, otherwise it will not work

Thanks. These two things (SelectAI and Vector Search) are two distinct things and have different use cases. Vector Search is used to index different types of objects (text, images, docs, etc.) to find similarities. You can use SelectAI to query your data. This will use the underlying table/objects in the DB and any indexes for faster retrieval, just like a B-tree index for certain data, and Vector Search index for it's associated data. I'll have some videos and blog posts on Vector Search coming soon. Watch out fo those.

Have a look on this playlist and you'll see videos for installing a pre-built 23ai Database for VirtualBox and Docker. If you want to install everything yourself then I'd suggest you check out and follow the instructions by Tim Hall. oracle-base.com/articles/23/oracle-db-23-free-rpm-installation-on-oracle-linux-8

@@b-tierney yes....will try out this...thank you...

I've multiple Free accounts, and it is appearing on most of them. Maybe they are still rolling it out. But in the Free accounts where I can see 23ai, make sure to have the slider on in the section 'Configure the Database' (See 0:56sec in video). The slider is labelled 'Show only Always Free configuration options'. Click on that and 23ai will now appear in the list

@b-tierney unfortunately this button doesn't appear for me

meaning, the check to "Show only Always Free configuration options".

@@NachoCTA I mentioned previously that they might be still rolling it out. If it doesn't appear soon contact Oracle support.

Same here using Toronto

Absolutely. Yes you can do anything using that connection, just like using any other SQL tool like SQL Developer etc

You could use something like this pd.read_sql(sql=sql, con=conn)

@@b-tierney thank you so much

That seems to be related to a firewall or something else that's restricting access to the DB

No details of what errors you encountered were given. You should be able to connect if the instructions were followed exactly as shown. Common errors occur when instructions are not followed exactly (e.g. using different case, words, etc)

I'm not sure what might be causing it, as I don't have the code and environment you are using. Have a look at the Oracle discussion forums to see if there is anything there that might help, and if not, post your error message, code, and setup there. forums.oracle.com/ords/apexds/domain/dev-community?tags=python

That error was a pain. You have to make a thick connection.

There are lots of options for using the Wallet. I've shown one example and is the default demo with the package. I'd suggest contacting the Oracle PM for python-oracle to explore the various options for using the Wallet.

Just use pd.read_sql() function with the connection you've just created

It's difficult to say what might be causing that error, but it looks like your python environment isn't finding the library. It could be due to the configuration on your computer, what OS you are using etc. Here is a link to useful link to the oracledb issues page github.com/oracle/python-oracledb/issues

Yes there is. This video was recorded before that happened.

There is a server side install and a client side install. Both are needed