11.2 - DBMS_DST error - ORA-56920: a prepare or upgrade window or an on-dem
749273Apr 9 2010 — edited Jun 11 2010Hitting this error after migration to 11.2 from 11.1 - notes say error below but how do I get past this?
error if a previous (prepare) window was not ended:
SQL> EXEC DBMS_DST.BEGIN_UPGRADE(11);
BEGIN DBMS_DST.BEGIN_UPGRADE(11); END;
*
ERROR at line 1:
ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading
of a secondary time zone data file is in an active state
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 1054
ORA-06512: at line 1