ORA-1 for parallel insert in partitioned table with a generated always as identity column
Hi Experts,
We have Oracle Database 19.18 on AIX.
In database we have table that partitioned by date (interval 1 Day) and subpartitioned by department code (26 subpartitions) and has column generated always as identity, with PK.
Every night starts 26 scheduled jobs, separate for each department, that loads data in this table. The total volume of loaded data is about 14 milions rows every night.
Load by stored procedure with code like (the identity column is not specified in INSERT):
"INSERT INTO TABLE TABLE_NAME (COL1,COL2,COL3,COL4)
SELECT COL1,COL2,COL3,COL4
FROM TABLE_NAME2 PARTITION (P_DEP_01) WHERE dDATE >=sysdate-1
LOG ERRORS INTO ERR$_TABLE_NAME REJECT LIMIT UNLIMITED"