Long Identifiers in Oracle 12.2 may cause trouble

LONG identifiers are one of the key features in Oracle Database But as I learned the other day, you should be a bit careful when you exchange data between different databases. In certain situations, Long Identifiers in Oracle 12.2 may cause trouble.

What are Long Identifiers?

Long identifiers get introduced with Oracle Database For ages, you could name a table or a column or a user or a package in Oracle with only 30 byte length. Hence, naming a table TAB_THIS_IS_MY_TABLE_AND_I_LIK is ok (30 byte – 30 characters) but naming it TAB_THIS_IS_MY_TABLE_AND_I_LIKE_IT is not possible as it requires … [ Read more ]