oracle – ORA-00972 – Identifier is too long

Od posmura

 

  • Cause: An identifier with more than 30 characters was specified.
  • Action: Specify at most 30 characters.
  • Many users find themselves encountering ORA-00972 when attempting to access a table that has a large column length. 
  • Furthermore, ORA-00972 can be caused by column, alias, or table names which are too long