Administrative Tasks for Oracle Machine Learning for SQL

Lists the administrative tasks related to Oracle Machine Learning for SQL. These tasks require the ADMIN role.

Table - Administrative Tasks for OML4SQL

Tasks	Roles	Interfaces/Tools	Links
Install and Configure a Database for Oracle Machine Learning for SQL	ADMIN	Oracle SQL Developer Oracle Data Miner	Install and Configure a Database for Oracle Machine Learning for SQL Database Tuning Considerations for Oracle Machine Learning for SQL System Privileges for Oracle Machine Learning for SQL Object Privileges for Oracle Machine Learning for SQL Models
Create OML user	ADMIN	SQL*Plus Oracle SQL Developer Note: You must have the SYSDBA role to create a user.	Create an Oracle Machine Learning for SQL User
Grant and Manage Privileges	ADMIN	Oracle SQL Developer SQL*Plus Visual Studio Code	Grant Privileges for Oracle Machine Learning for SQL
Export and Import Oracle Machine Learning for SQL Models	ADMIN	Export and Import functions of Oracle AI Database DBMS_DATA_MINING package Command-line clients of Oracle Data Pump	Export and Import Oracle Machine Learning for SQL Models Options for Exporting and Importing Oracle Machine Learning for SQL Models Use EXPORT_MODEL and IMPORT_MODEL EXPORT and IMPORT Serialized Models Directory Objects for EXPORT_MODEL and IMPORT_MODEL Import From PMML
Audit and Add Comments to Oracle Machine Learning for SQL Models	ADMIN USER	SQL COMMENT statement Oracle AI Database auditing system	Add a Comment to a Oracle Machine Learning for SQL Model Audit and Add Comments to Machine Learning for SQL Models
Upgrade OML4SQL	ADMIN	Database Upgrade Assistant	Pre-Upgrade Steps Use Database Upgrade Assistant to Upgrade Oracle Machine Learning for SQL Use Export/Import to Upgrade Machine Learning for SQL Models Post Upgrade Steps
Downgrade OML4SQL	ADMIN	Database Upgrade Assistant	Downgrade Oracle Machine Learning for SQL