Datapatch Fails with "ORA-01732: data manipulation operation not legal error" (Doc ID 2058586.1)

Last updated on OCTOBER 08, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

 After applying one-off Patch 21290101 , post install step produces below error

$ datapatch

Validating logfiles...
DBD::Oracle::st execute failed: ORA-01732: data manipulation operation not legal on this view (DBD ERROR: error possibly near <*> indicator at char 7 in 'UPDATE <*>dba_registry_sqlpatch
SET status = :p1, action_time = SYSTIMESTAMP
WHERE patch_id = :p2
AND patch_uid = :p3
AND action = UPPER(:p4)
AND action_time = (SELECT MAX(action_time)
FROM dba_registry_sqlpatch
WHERE patch_id = :p5
AND patch_uid = :p6
AND action = UPPER(:p7))') [for Statement "UPDATE dba_registry_sqlpatch
SET status = ?, action_time = SYSTIMESTAMP
WHERE patch_id = ?
AND patch_uid = ?
AND action = UPPER(?)
AND action_time = (SELECT MAX(action_time)
FROM dba_registry_sqlpatch
WHERE patch_id = ?
AND patch_uid = ?
AND action = UPPER(?))" with ParamValues: :p1='SUCCESS', :p2='19877336', :p3='18313828', :p4='apply', :p5='19877336', :p6='18313828', :p7='apply'] at /u01/app/oracle/product/12.1.0/dbhome/sqlpatch/sqlpatch.pm line 2659.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms