I wonder what is really at play here too. If you use the DYNAMIC OUTPUT IN-DB tool you can see the SQL. Google says that the error is that the field name that you are creating is more than 30 characters long.
ORA-00972: identifier is too long tips. Cause: An identifier with more than 30 characters was specified. Many users find themselves encountering ORA-00972when 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.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
to my youTube channel.