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 Interfaces/Tools Links
Install and Configure a Database for Oracle Machine Learning for SQL
  • Oracle SQL Developer
  • Oracle Data Miner
Create OML user
  • SQL*Plus

Note:

You must have the SYSDBA role to create a user.
Grant and Manage Privileges
  • Oracle SQL Developer
Export and Import Oracle Machine Learning for SQL Models
  • Export and Import functions of Oracle Database
  • DBMS_DATA_MINING package
  • Command-line clients of Oracle Data Pump
Audit and Add Comments to Oracle Machine Learning for SQL Models
  • SQL COMMENT statement
  • Oracle Database auditing system
Upgrade OML4SQL
  • Database Upgrade Assistant
Downgrade OML4SQL
  • Database Upgrade Assistant