Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12899 - is it possible to truncate automatically

686423Jun 9 2009 — edited Jun 9 2009

I know why I am getting ORA-12899. Instead of rolling back the transaction, I am wondering if it is possible to let Oracle truncate data automatically so that update/insert succeeds. There are cases that auto-truncation is acceptable.

I am using Oracle 10 with Hibernate.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2009

Added on Jun 9 2009

#general-database-discussions

4 comments

2,457 views