OraFAQ Forum: Designer » Maximum name sizes

Home » Developer & Programmer » Designer » Maximum name sizes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Maximum name sizes [message #90498]

Tue, 09 December 2003 08:28

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

Report message to a moderator

Re: Maximum name sizes [message #90502 is a reply to message #90498]

Sat, 13 December 2003 22:36

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.

Report message to a moderator

Re: Maximum name sizes [message #90504 is a reply to message #90498]

Mon, 15 December 2003 00:53

Neeraj A
Messages: 2
Registered: December 2003

Junior Member

In oracle 9i table and colum name can be 30 characters long.

Report message to a moderator

Re: Maximum name sizes [message #90505 is a reply to message #90502]

Mon, 15 December 2003 19:35

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

Report message to a moderator

Re: Maximum name sizes [message #90508 is a reply to message #90498]

Tue, 23 December 2003 05:42

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

See Oracle 9i SQL Reference, "Schema Object Naming Rules".

Report message to a moderator

Re: Maximum name sizes [message #90550 is a reply to message #90505]

Thu, 19 February 2004 03:15

Jorge Izabel
Messages: 1
Registered: February 2004

Junior Member

A very interesting site, with important information to be found.

Thank you.

Report message to a moderator

Re: Maximum name sizes [message #90562 is a reply to message #90505]

Tue, 09 March 2004 09:48

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?

Report message to a moderator

Previous Topic:	table design
Next Topic:	oracle dsn

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 04:56:20 CST 2025