My Oracle Support Banner

Goldengate Monitor Installation Error : ORA-00439: Feature Not Enabled: Partitioning (Doc ID 2406430.1)

Last updated on DECEMBER 12, 2019

Applies to:

Management Pack for Oracle GoldenGate - Version and later
Information in this document applies to any platform.


During installation Oracle goldengate monitor faced ORA-00439: feature not enabled: Partitioning error as mentioned below.Ignoring error and pressing continue did not work.

Error Detail:

MSK 2018 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 439SQLState:67000 Message: ORA-00439: feature not enabled: Partitioning

Error encountered executing SQL statement FileName: '/ora/ggmon/middleware/12.2/oggmon/common/sql/oggmon/scripts/Oracle/create-schema.sql' LineNumber: '29'
SQL Statement: [CREATE TABLE mps_history (ID NUMBER(10) NOT NULL, mp_type VARCHAR2(31) NULL, string_array_value CLOB NULL, string_value VARCHAR2(4000) NULL, double_value NUMBER(19,4) NULL, connection_value NUMBER(10) NULL, mp_date TIMESTAMP NULL, boolean_value NUMBER(1) default 0 NULL, long_value NUMBER(19) NULL, float_value NUMBER(19,4) NULL, status_value NUMBER(10) NULL, date_value TIMESTAMP NULL, int_value NUMBER(10) NULL, mp_id NUMBER(10) NULL, PRIMARY KEY (ID)) PARTITION BY RANGE (mp_date) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) (PARTITION MPS_HISTORY_1 VALUES LESS THAN (to_date('2001-01-01', 'YYYY-MM-DD')))]
java.sql.SQLException: ORA-00439: feature not enabled: Partitioning


GoldenGate Monitor :
Release Version:
Build Label: OGGMON_12.

Repository database :
Oracle Database 12c Standard Edition Release - 64bit Production

Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_12.
Linux, x64, 64bit (optimized), Oracle 11g on Dec 8 2017 21:13:00


Got "ORA-00439: feature not enabled: Partitioning" error during Oracle goldengate monitor installation.


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

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