DST Upgrade using DBMS_DST.BEGIN_PREPARE fail with ORA-2014 (Doc ID 1407273.1)

Last updated on OCTOBER 09, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2016***

Symptoms

When trying to upgrade the DST to a higher version (e.g. following the steps from <Note 977512.1> Updating the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST), the following error is reported:

E.g.

SQL> exec DBMS_DST.BEGIN_PREPARE(14);
BEGIN DBMS_DST.BEGIN_PREPARE(14); END;

*
ERROR at line 1:
ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
ORA-06512: at "SYS.DBMS_DST", line 1324
ORA-06512: at line 1


The alert log could show similar errors in the past on different components/processes:

E.g.

Mon Feb 06 22:00:26 2012
Errors in file test_j001_21242.trc:
ORA-12012: error on auto execute of job 76525
ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 1544
ORA-06512: at "SYS.DBMS_SPACE", line 1610

Changes

None.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms