ORA-00972: Identifier Is Too Long / How to Shorten Asset Type Table Names

(Doc ID 2339273.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 to 11.1.1.8.0 [Release FatWire]
Information in this document applies to any platform.

Goal

How can we shorten asset type table names (Oracle DB <12cR2 has a 30 bytes limitation (not to be confused with 30 characters limitation, if ASCII format is used indeed limitation is equivalent))?

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