Skip to Main Content

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!

How many columns can handle by triggers

Hi All,

We are currently developing DML datafix automation. When taking a backup of the table before executing the datafix, we utilize triggers to create the backup. However, we encountered an issue while backing up the table. The table contains 723 columns, and during the backup process through triggers, it failed with the error below.

Error report - ORA-20099: ORA-24344: success with compilation error

Please suggest, how many columns will handle by triggers?

Comments
Post Details
Added on Apr 10 2025
3 comments
192 views