Traditional STARETL Fails With the Following Error - ORA-28132: The MERGE INTO syntax does not support the security policy (Doc ID 2925033.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Symptoms

When attempting to execute the traditional staretl,
the following error occurs.

ERROR
-----------------------
2023-01-26 14:29:31.804 [main] INFO ETL.Message - === Step 12, Part 1 ====================================================
2023-01-26 14:29:31.805 [main] INFO ETL.Message - === Validate Meta Data Syntax (metadata\validate_work_down_update_stmts.sql)
2023-01-26 14:29:32.280 [Thread-2] INFO ETL.Message - declare
2023-01-26 14:29:32.281 [Thread-2] INFO ETL.Message - *
2023-01-26 14:29:32.282 [Thread-2] INFO ETL.Message - ERROR at line 1:
2023-01-26 14:29:32.282 [Thread-2] INFO ETL.Message - ORA-28132: The MERGE INTO syntax does not support the security policy.
2023-01-26 14:29:32.282 [Thread-2] INFO ETL.Message - ORA-06512: at "STARUSER.WORKDOWN_UPDATE", line 1426
2023-01-26 14:29:32.284 [Thread-2] INFO ETL.Message - ORA-06512: at line 4
2023-01-26 14:29:32.288 [main] INFO ETL.Progress - Step 12/78 Part 1/1 - FAILED (28132) (0 hours, 0 minutes, 1 seconds, 569 milliseconds)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the staretl.bat.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.