Data Loss Prevention

 View Only

  • 1.  Error ORA-02270

    Posted Aug 12, 2014 10:04 AM

    While upgrading to the 12.5 version I've got the error:

     

    Upgrader Error Messages:

    TASK_ID     : 2

    TASK_NAME   : Pre Upgrade Schema

    BATCH_NUM   : 2

    ERROR_TYPE  : FATAL

    ERRANT_STMT : ALTER TABLE DATAUSER_UNIQUELOGINS_STG ENABLE CONSTRAINT DATAUSER_UNIQUELOGINS_STG_FK1

    ERROR       : ORA-02270: no matching unique or primary key for this column-list

     

    Does anybody know what it means and how to fix it?



  • 2.  RE: Error ORA-02270
    Best Answer

    Posted Aug 13, 2014 10:16 AM

    We had a similar error upgrading to version 12 and support was able to provide a script that cleaned up the tables to prep for the upgrade.

     



  • 3.  RE: Error ORA-02270

    Posted Aug 14, 2014 03:26 AM

    Thank you for sharing this information.

    I will contact the Symantec support.



  • 4.  RE: Error ORA-02270

    Posted Aug 19, 2014 03:05 AM

    Dear , First please chcek upgradation process priorities and prerequisites. I think there is issue with user account schema/table not matching during upgradtion according to DLP apps 12.5