DST Upgrade using DBMS_DST.BEGIN_PREPARE fail with ORA-2014
(Doc ID 1407273.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and laterInformation in this document applies to any platform.
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
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
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
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 |