Max Number Character Allow On 9i

Hi all,

on 8i , the max number character on table and columns are 30 characters??? What about 9i ??? has it been changed??? or it's still the same ???

Thanks

this kind of question are answered perfectly in tahiti.oracle.com

RTFM

Pando,

always appreciate for all the help you have provided in this forum. I was pretty know the max is 30 characters but I have to prove this to my manager so that I need some documentation to support this.

I have look into metalink and tahiti.oracle.com but I didn't see any valid point to support this. Would you please let me know what should I look for ???

thanks

Here's the proof:

SQL> create table this_table_name_has_31_charactr (col1 number)

create table this_table_name_has_31_charactr (col1 number)
*
ERROR at line 1:
ORA-00972: identifier is too long


SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

As I mentioned earlier. I did the same thing here. I guess what I am looking for here is the documentation.

tahiti.oracle.com

I found it in 3 minutes...

http://download-west.oracle.com/docs...ts9a.htm#27566 and scroll down a bit