I want to the varchar2 max size in oracle8.1.7.4.0 for solaris.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: I want to the varchar2 max size in oracle8.1.7.4.0 for solaris.

  1. #1
    Join Date
    Mar 2001
    Posts
    40

    I want to the varchar2 max size in oracle8.1.7.4.0 for solaris.

    hi,

    I have a table in coracle8.1.7.4.0 for solaris, there is a column of varchar2. firstly, I set its size 4000, then I want to extend to 8000, but there is a oracle error ora-00910 which said that specified length too long for the datatype. I looked up the docs, and it said the max size can be up to 32767. now I confused of it and don't know what i can do to extend the column size. You advice will be appreciate.

    -GAO

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    4000 is the max for varchar2.

    http://technet.oracle.com/docs/produ...elem.htm#45443

    HTH.

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    A VARCHAR2 *variable* can be 32767, but a column can only be 4000. But be careful, because Oracle was sloppy when they changed from 2000 to 4000. DBMS_SQL.Varchar2_Table is still defined at 2000, for example, so it won't work for larger columns. So much for consistency, eh?

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

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