DBMS_WM.BeginDDL = ORA-20202

(Doc ID 1323936.1)

Last updated on MAY 20, 2011

Applies to:

Workspace Manager - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Calling DBMS_WM.BeginDDL fails in SQL*Plus:

SQL> exec dbms_wm.beginddl('COLA_MARKETING_BUDGET');
BEGIN dbms_wm.beginddl('COLA_MARKETING_BUDGET'); END;

*
ERROR at line 1:
ORA-20202: index name PK_COLA_MARKETING_BUDGET_ID is longer than 26 characters
ORA-06512: at "WMSYS.LT", line 12253
ORA-06512: at line 1

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