This article describes the maximum length that a table name can use in the Oralce database. This length is also the maximum length of the Oracle identifier, which is 30 characters.
Small weave today, when an Oracle database table is being built, it is suggested that the following table name is longer than the maximum value. The error is as follows:
Copy Code code as follows:
Error Reporting:
SQL Error: ORA-00972: identifier too long
00972.00000-"identifier is too long"
*cause:an identifier with further than characters was specified.
*action:specify at most characters.
From this error hint you can see:
1, the so-called identifier, that is, user-defined keywords, comparison table name, field name, view name, sequence name, primary key, etc., the table name also belongs to the identifier.
2, the identifier has the length limit.
3, the maximum length of an identifier is 30 characters in Oracle.
So, in the future, when we're working on Oracle databases, be careful not to set the table name to longer than 30 characters long.