I'm testing the Oracle Cloud Free Tier currently, with plans to go live with our Apex solution on the paid tier. Search using Oracle Text is a key component. When using Oracle Text I am able to create an index, but there doesn't appear to be privileges to use CTX_DDL to create preferences. Does anyone know if this is a matter of licensing, or do Oracle Cloud users not have the ability to create preferences? Is there another way in the Cloud to create preferences using Apex procedures that I'm unfamiliar with maybe?
I searched the forums and docs, but there's only a slight nod given to Oracle Text for Cloud applications, and nothing that I found references CTXSYS package definitions or access. I'd appreciate any insights. -- Ron (display name updated but not showing here yet)