Home / 12c / Long Identifiers in Oracle Database 12c Release 2 (12.2)

Long Identifiers in Oracle Database 12c Release 2 (12.2)

Long Identifiers

Oracle 12.2 increased the maximum size of most identifiers from 30 to 128 bytes, which makes migration from different database engines simpler.  the size of identifiers is matter of migration from one database to another type of database.

At a specific point, each DBA or Developer can have danger a point where the 30 character limit for object name has a reason of a problem. This  restrict could be extraordinarily painful when doing migration entire projects from  MySQL to Oracle Database. In Oracle DB 12R2, the maximum size of most identifiers is now 128 characters. Let us see an example:

As anticipated, this variation has filtered by many areas of the system together with the dictionary views and JVM.

Backwards Compatibility

In case you are able the place you’re supporting multiple versions of the database, you will want to keep away from using lengthy identifier names, or you’ll stop backward compatibility.

For more information see:

Long Identifiers

Oracle 12.2 increased the maximum size of most identifiers from 30 to 128 bytes, which makes migration from different database engines simpler.  the size of identifiers is matter of migration from one database to another type of database.

At a specific point, each DBA or Developer can have danger a point where the 30 character limit for object name has a reason of a problem. This  restrict could be extraordinarily painful when doing migration entire projects from  MySQL to Oracle Database. In Oracle DB 12R2, the maximum size of most identifiers is now 128 characters. Let us see an example:

[crayon-5bc6524438fe0268614750/] As anticipated, this variation has filtered by many areas of the system together with the dictionary views and JVM.
[crayon-5bc6524438fee493288799/]

Backwards Compatibility

In case you are able the place you’re supporting multiple versions of the database, you will want to keep away from using lengthy identifier names, or you’ll stop backward compatibility.

For more information see:

Check Also

7cf484ceeae6bc7fc2161eddc603cd15.jpeg

Oracle Database 12c – How to Add / Multiplex Control Files

PURPOSE: – protect your Database in case of a disk failure – reduce the risk …

a2b042fe070145288fbcd8df3f1198ed.png

Oracle Database 12c Release 1 (12.1) Installation on Oracle Linux 7 (OL7.2)

Table of Contents ▼▲ Note from Oracle Database 12c R1 Installation Guide: Starting with Oracle …

Leave a Reply