SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes and if you try to create object with length more than 30, it will throw error as ORA-00972: identifier is too long.
Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which makes migration from other database engines easier.

The same command i tried to run in previous  Oracle 12.1.0.2 database.

You can describe the dba_table and check the length of columns.( In oracle 12.2)

Leave a Reply

Your email address will not be published. Required fields are marked *