In Oracle, the maximum length for a table name is 30 characters. This applies to both the table name and the schema name, which are concatenated to form the fully qualified table name. The fully qualified table name in Oracle is made up of the schema name, the name of the user, or the name of the schema that owns the table, followed by a period (.) and the table name. For example, in the fully qualified table name "SCOTT.EMPLOYEES", "SCOTT" is the schema name, and "EMPLOYEES" is the table name. The maximum length for a fully qualified table name is 30 + 1 + 30 = 61 characters.
It's important to note that this limit applies to Oracle Database releases before Oracle Database 18c. In 18c and later releases, the maximum length for table names and other identifiers has been increased to 128 characters.
Also, it's a best practice to use descriptive and meaningful table names to make it easier to understand the data and its purpose, even if the names are shorter than the maximum length allowed by Oracle.
0 Komentar