Re: question about insert operation

music4 wrote:

> Greetings,
>
> I'am writing a program that keeps receiving data from other process and
> insert the data into a db table. Now I'm think this question: is there any
> case that "INSERT" operation fail, but next try will success? (you can
> ingore software bug case)
>
> The case I can figure out are:
> 1) Session exceed maximun limit
> 2) Table space is full
>
> Any others? Please help!
>
> Thanks in advance!
> evan

1. Primary key constraint violated
2. Foreign key constraint violated
3. Check constraint violated
4. NOT NULL constraint violated
5. Invalid data type (a non date, or invalid date, in a date field for example)
6. Unique constraint (index) violation
7. Failure of table level trigger due to dependency on another object

Your examples above, restated here and added to:

8. Table has reached max extents
9. Tablespace is full

10. Tablespace can't autoextend because drive is full
11. Session violates some criterion in the user's profile
12. Tablespace is off-line
13. Tablespace is made read-only

violate your criterion that the next try might succeed. With any of these the next attempt will also fail.

Undoubtedly there are others that can be added to both lists.

Daniel Morgan Received on Tue Dec 24 2002 - 23:05:09 CST