BUG

Attempting to rename a table in Oracle fails with an underlying DBMS error

Last Published: April 25, 2020

Description

Attempting to rename an Oracle table fails with an underlying DBMS error:

"SQL> RENAME tr_conductoranno100cond_bk TO tr_conductoranno100cond;
RENAME tr_conductoranno100cond_bk TO tr_conductoranno100cond
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1"

Cause

This DBMS error occurs because a local string variable's length in the sde trigger st_rename_table is not defined large enough to support an input string value.

Anytime a table is renamed in Oracle, the sde trigger st_rename_table is executed to check if the table being renamed contains a sde.st_geometry attribute and updates the st_geometry metadata accordingly in the SDE schema.

Workaround

If this error is encountered when attempting to rename a table in Oracle, please contact ESRI Support Services and reference this knowledge base (KB) article.

    Article ID: 000010173

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options