LONG identifiers are one of the key features in Oracle Database 184.108.40.206. 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 220.127.116.11. 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 ]