Enforcing function/constant names length in Oracle 18 to be 30 characters


in Oracle 18 is there a way to enforce the max length of function names (and constant-names) to be 30 chars only (as it is in Oracle 11 and priors)?

Best Answer

In general it appears that the answer is "no". Allowable object name length is a function of the COMPATIBLE initialization parameter. See here:

This parameter is usually intended to ensure your ability to downgrade an Oracle version to a previous release following an unsuccessful upgrade. Once set to a higher value, it cannot be lowered again, as it will have an impact on the data dictionary and other Oracle internal features. See here: