When using the OPSWWTUTOR.DMP file from the OracleServerSetup (OPSORAsvrSetup.exe) install (version 2.2.0). Import the DMP file and use Server Setup to upgrade database get error:
Database Upgrade Failed:
The Log file shows in fails on the following line trying to alter the BODRECS table.
alter table BODRECS modify("AUDITUSER" varchar2(50) default NULL, "SAMPLENAME" nvarchar2(50), "BOTTLENUM" nvarchar2(50), "PREDIL" nvarchar2(50), "INITTEMP" float, "INITPH" float, "FINALTEMP" float)
09:49:50 AM : Script execution failed :
09:49:50 AM : 1440 - -2147217900 - ORA-01440: column to be modified must be empty to decrease precision or scale
09:49:50 AM : Upgrade136Facility() return value = False
The INITTEMP field had data in it (there are 13 records). We set the INITTEMP data to null before starting the database upgrade and successfully upgraded!!
To set INITTEMP to Null, use SQL_CONSOLE and execute the following command against the OPSWWTUTOR database:
update bodrecs set INITTEMP=null
WARNING - DO NOT USE THE ABOVE STATEMENT AGAINST A USER DATABASE AS IT WILL CLEAR THE DATA. YOU NEED TO CHECK THE BODRECS TABLE BEFORE PROCEEDING.