Identifier lengths on Oracle databases

• On Oracle databases, table and view names must not be greater than 24 characters.
• On Oracle databases, column and relation names must not be greater than 30 characters.
• On Oracle databases, index names must not be greater than 30 minus the length of the table name.
  
  For example, on the employee table, the name of an index added to this table cannot be greater than 22 characters.
  
  30 - length("employee") = 30 - 8 = 22

Did this topic help you? Email us your feedback.
Last updated: 1/3/2008 2:17:39 PM
© by Dovetail Software, Inc.