Setting an AI Profile on a Database Connection

You must associate one of the AI Profiles that you have created with the Oracle Database connection that you wish to use with Select AI.

1. In Database Explorer, connect to the Autonomous Database as your database user. See Connecting to Oracle Autonomous Database (ADB).

2. In the connection dialog, optionally check Show More Options, and then select a profile from the Default AI Profile dropdown.

3. Right click on the connection and select Open New SQL File, or Open Existing SQL File.

4. In the SQL file, if you did not choose a Default AI Profile in the connection dialog, then run this PL/SQL block (you will need to do this each time you connect):

   begin
    dbms_cloud_ai.SET_PROFILE('yourprofilename');
   end;
   /