ORA Error ReferenceSearch errors

All errors › ORA errors

ORA-00972: Identifier is too long

What it means

An identifier is longer than allowed: 30 bytes before 12.2, 128 bytes from 12.2 (with COMPATIBLE >= 12.2).

How to fix it

Shorten the name, or check the COMPATIBLE parameter of the database.

Catch it before it runs

ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip.
PL/SQL Lint
Flags risky PL/SQL patterns while you type.
Oracle Plan Reader
Reads execution plans and points at the slow step.
PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.

Nearby errors

Updated 2026-11-12.