ORA-00972: identifier is too long
Oracle PL/SQL error message: ORA-00972: identifier is too long.
Cause:
You try to create an object name with more than 30 characters was specified.
Solution:
Specify at most 30 characters for the object name.
Example:
CREATE OR REPLACE VIEW AAAAA_BBBBB_CCCCC_DDDDD_12345678 AS SELECT * FROM TEST3;
Output:
ORA-00972: identifier is too long
Correct:
CREATE OR REPLACE VIEW AAAAA_BBBBB_CCCCC_DDDDD_12345 AS SELECT * FROM TEST3;
Output:
view AAAAA_BBBBB_CCCCC_DDDDD_12345 created.