Error In Soa Truncate Sql Script (Doc ID 2407851.1)

Last updated on AUGUST 08, 2023

Applies to:

Goal

The script to truncate the tables in the soainfra schema has some semicolons missing so some truncate statements are not executed.

script name:
<product_home>/soa/common/sql/soainfra/sql/oracle/122130/truncate/truncate_soa_oracle.sql

lines 281 - 283:
TRUNCATE TABLE BRDECISIONFAULT
TRUNCATE TABLE BRDECISIONINSTANCE
TRUNCATE TABLE BRDECISIONUNITOFWORK

lines 310-318:
TRUNCATE TABLE BPM_AUDIT_QUERY
TRUNCATE TABLE BPM_AUDIT_QUERY_VARVALS_EXT1
TRUNCATE TABLE BPM_CUBE_AUDITINSTANCE
TRUNCATE TABLE BPM_CUBE_LASTSNAPSHOT
TRUNCATE TABLE BPM_CUBE_PROCESSPERFORMANCE
TRUNCATE TABLE BPM_CUBE_TASKPERFORMANCE
TRUNCATE TABLE BPM_CUBE_WORKLOAD
TRUNCATE TABLE BPM_MEASUREMENT_ACTION_EXCEPS
TRUNCATE TABLE BPM_MEASUREMENT_ACTIONS

Solution

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