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

Thread: production error

  1. 09-18-2003, 08:05 AM #1
    newcomer
    newcomer is offline Member
    Join Date
    May 2002
    Posts
    163

    production error

    hey guys

    What can be the reason for this error?
    ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces
    Nwcomer
    Student
    Reply With Quote Reply With Quote
  2. 09-18-2003, 08:25 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what version and what were you trying to do when you got that error
    Reply With Quote Reply With Quote
  3. 09-18-2003, 08:44 AM #3
    newcomer
    newcomer is offline Member
    Join Date
    May 2002
    Posts
    163
    oracle 9.2.0.4.0


    I have a table with Index organised index and trying to create the table


    Thanks
    Nwcomer
    Student
    Reply With Quote Reply With Quote
  4. 09-18-2003, 08:47 AM #4
    vishal sood
    vishal sood is offline oracle DBA
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    As mentioned in Oracle 9i Documentation

    ORA-01429 Index-Organized Table: no data segment to store overflow row-pieces

    Cause: No overflow segment defined.

    Action: Add overflow segment.
    vishal sood
    OCP 8
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width