My Oracle Support Banner

DBMS_DATA_MINING QUERY FAILS WITH ORA-01031 (Doc ID 2556211.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

DBMS_DATA_MINING QUERY FAILS WITH ORA-01031

BEGIN
  DBMS_DATA_MINING.CREATE_MODEL (
  model_name => '<model name>',
  mining_function => <mining function name>,
  data_table_name => '<table name>',
  case_id_column_name => 'ID',
  target_column_name => NULL,
  settings_table_name => '<table name>');
END;
/

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DATA_MINING", line 1796
ORA-06512: at line 2

Changes

Oracle Database Vault and Oracle Label Security are enabled.

SQL> SELECT PARAMETER, VALUE FROM V$OPTION;

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Oracle Label Security TRUE
Oracle Database Vault TRUE

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.