Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    4

    Question Unanswered: Oracle 9i Column Limit

    I have been searching for the spec in 9i that discusses column limits. I read that in 8i, the column limit is 1000. Does anyone know what the max number of columns for a single table is?

    TIA

  2. #2
    Join Date
    May 2003
    Posts
    87

    Re: Oracle 9i Column Limit

    same as 8i -- 1000 !!!

    see http://download-west.oracle.com/docs...00.htm#1001271

    Originally posted by cbock
    I have been searching for the spec in 9i that discusses column limits. I read that in 8i, the column limit is 1000. Does anyone know what the max number of columns for a single table is?

    TIA

  3. #3
    Join Date
    May 2003
    Posts
    4
    Thanks dbmadcap. And for anyone else with this question...here's what was found via the link provided.

    ORA-01792 maximum number of columns in a table or view is 1000

Posting Permissions

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