Home » Developer & Programmer » Designer » Maximum name sizes
Maximum name sizes [message #90498] Tue, 09 December 2003 08:28 Go to next message
Mike Nibeck
Messages: 49
Registered: May 2002
Member
Anyone know the maximum length for table and column names in 9??

Anyone know which Oracke doc outlines this, cause I can't find it anywhere.

- Mike
Re: Maximum name sizes [message #90502 is a reply to message #90498] Sat, 13 December 2003 22:36 Go to previous messageGo to next message
samm khan
Messages: 9
Registered: November 2003
Junior Member
the max. length for any database object(table,column...) is 32 and for the database name
the max lenght is 8.
Re: Maximum name sizes [message #90504 is a reply to message #90498] Mon, 15 December 2003 00:53 Go to previous messageGo to next message
Neeraj A
Messages: 2
Registered: December 2003
Junior Member
In oracle 9i table and colum name can be 30 characters long.
Re: Maximum name sizes [message #90505 is a reply to message #90502] Mon, 15 December 2003 19:35 Go to previous messageGo to next message
ubaid
Messages: 2
Registered: December 2003
Junior Member
Feature ========> Oracle 9i Database
database name length==> 8
column name length ==> 30
index name length ==> 30
table name length ==> 30
view name length ==> 30
stored procedure name length==> 30
most columns per table ==> 1000
most columns in an index key==> 32
max number of columns in GROUP BY ==> 255
max number of columns in ORDER BY==> 255
longest index key ==> 3155
max varchar() size ==> 4000
max char() size ==> 2000
max table row length==> 255000
longest SQL statement==> 16777216
recursive subqueries ==> 64
constant string size in SELECT==> 4000
Re: Maximum name sizes [message #90508 is a reply to message #90498] Tue, 23 December 2003 05:42 Go to previous messageGo to next message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
See Oracle 9i SQL Reference, "Schema Object Naming Rules".
Re: Maximum name sizes [message #90550 is a reply to message #90505] Thu, 19 February 2004 03:15 Go to previous messageGo to next message
Jorge Izabel
Messages: 1
Registered: February 2004
Junior Member
A very interesting site, with important information to be found.

Thank you.
Re: Maximum name sizes [message #90562 is a reply to message #90505] Tue, 09 March 2004 09:48 Go to previous message
stan
Messages: 7
Registered: October 1999
Junior Member
I'm needing to know what is the maximum length that a char based column can be and still be an indexed column. If I interpret your table above, it would be 2000. Is that a correct interpretation on my part?
Previous Topic: table design
Next Topic: oracle dsn
Goto Forum:
  


Current Time: Wed Jul 15 04:19:55 CDT 2020