DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Max Row Size

  1. #1
    Join Date
    Sep 2000
    Posts
    96
    What is the max row size in an Oracle Database Table?

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    i guess it depends on the no. of column and column width.

    cheese
    anandkl
    anandkl

  3. #3
    Join Date
    Sep 2000
    Posts
    96
    So, since there is a limit of 1000 columns per table, are you saying that my only limitation on row size is that there be no more than 1000 columns in that row?

  4. #4
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    That seems to be the case - heres an answer from an Oracle Support forum:

    In Oracle8/Oracle8i, a table can have a maximum of 1000 columns. There are size and number restrictions on the datattype(s) of the columns. Those restrictions are what imposes a limit on the row size.

  5. #5
    Join Date
    Sep 2000
    Posts
    96
    Great....thanks for all your help!

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