What are the maximum length of a table name and column name in Oracle?
Oracle – the maximum length of a table name in Oracle
name-lengthoracle
Related Topic
- Sql – the difference between Views and Materialized Views in Oracle
- Sql – Oracle: how to UPSERT (update or insert into a table?)
- Maximum filename length in NTFS (Windows XP and Windows Vista)
- Sql – How to limit the number of rows returned by an Oracle query after ordering
- Sql – Oracle: If Table Exists
- Javascript – Maximum length of variable name in JavaScript
- Java – How to connect to Oracle using Service Name instead of SID
- Sql – Oracle SQL: Update a table with data from another table
Best Answer
In Oracle 12.2 and above the maximum object name length is 128 bytes.
In Oracle 12.1 and below the maximum object name length is 30 bytes.