What is the maximum length supported by the Oracle database table name?

What is the maximum length supported by the Oracle database table name?

This article describes the maximum length that can be used by a table name in the Oralce database. The length is also the maximum length of the Oracle identifier, which is 30 characters.

When creating an Oracle database table today, xiaobian prompts that the following table name length has exceeded the maximum value. The error is as follows:

Copy codeThe Code is as follows:
Error Report:
SQL error: ORA-00972: The identifier is too long
00972. 00000-"identifier is too long"
* Cause: An identifier with more than 30 characters was specified.
* Action: Specify at most 30 characters.

The error message is as follows:

1. The so-called identifier, that is, the 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 a length limit.

3. the maximum length of the identifier is 30 characters in Oracle.

Therefore, when operating the Oracle database, do not set the table name length to more than 30 characters.

How many tables can be defined in the oracle database? Four questions

It may be based on the size of the defined database,
And table size

What type of string can be received by the oracle database?

Correction: varchar2 is a maximum of 4000 bytes, not a character.