Max Number Character Allow On 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Max Number Character Allow On 9i

  1. #1
    Join Date
    Jan 2002
    Posts
    474

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    this kind of question are answered perfectly in tahiti.oracle.com

    RTFM

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    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

  4. #4
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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

  5. #5
    Join Date
    Jan 2002
    Posts
    474
    As I mentioned earlier. I did the same thing here. I guess what I am looking for here is the documentation.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    tahiti.oracle.com

    I found it in 3 minutes...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    May 2002
    Posts
    2,645

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width