Database Administration (MOSC)

MOSC Banner

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center