This error is associated with the UPDATE
statement, which could be SQL based or could be in MLOAD
.
Various times, while updating the set of rows in a table, the update fails on Failure 7547 Target row updated by multiple source rows
.
This error will happen when you update the target with multiple rows from the source. This means there are duplicated values present in the source tables.
Let's create sample volatile tables and insert values into them. After that, we will execute the UPDATE
command, which will fail to result in 7547:
- Create a
TARGET TABLE
with the following DDL and insert values into it:
** TARGET TABLE**
create volatile table accounts
(
CUST_ID,
CUST_NAME,
Sal
)with data
primary index(cust_id)
insert values (1,'will',2000);
insert values (2,'bekky',2800);
insert values (3,'himesh',4000);
- Create a
SOURCE TABLE
with the following DDL and insert values into it:
** SOURCE TABLE**
create volatile table Hr_payhike
(
CUST_ID,
CUST_NAME,
Sal_hike
) with...