Menu

#11 Error unique constraint (BLOG_HTTP410_PK) violated when deleting file

2.9.0.2
progress
None
bug
schema object
2016-09-07
2015-01-03
Jari Laine
No

How reproduce issue:
Upload file and then delete it.
Upload same file again.
When deleting file second time error unique constraint (BLOG_HTTP410_PK) violated is raised.

Discussion

  • Jari Laine

    Jari Laine - 2015-01-03

    Workaround:
    Run in SQL Workshop
    alter table blog_http410 drop constraint blog_http410_pk
    /

     
  • Jari Laine

    Jari Laine - 2016-09-07

    Workaround applied to APEX 5 application export