MedWatch temp table generating: ORA-01758: table must be empty to add mandatory (NOT NULL) column (Doc ID 361067.1)

Last updated on APRIL 12, 2006

Applies to:

Adverse Event Reporting System - Version: 4.5.1
Information in this document applies to any platform.

Goal

Apply AERS iPatch 4.5.1.6 and got the following
error during execution of the 4163642_medwatchtemp_table.sql script:

alter table MEDWATCHTEMP
*
ERROR at line 1:
ORA-01758: table must be empty to add mandatory (NOT NULL) column




Solution

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