Upgrade from CS6 to CS7.x throws ORA-00972: identifier is too long exception (Doc ID 1434653.1)

Last updated on JANUARY 05, 2016

Applies to:

Oracle WebCenter Sites - Version: 6.3.0 to 6.3.11 - Release: FatWire to FatWire
Information in this document applies to any platform.

Goal

How to resolve the issue when upgrading from CS 6.3 to CS 7 and the following messages are seen in the logs:

[CS.INSTALL][INFO] UPGRADE version= Burns3
[CS.DB][ERROR] SQLException executing statement: CREATE TABLE [tablename]
java.sql.SQLException: ORA-00972: identifier is too long at Oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

Solution

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