Forum Stats

  • 3,817,367 Users
  • 2,259,322 Discussions
  • 7,893,760 Comments

Discussions

Importing a page from different App and Workspace - ORA-00001: unique constraint (APEX_050100.WWV_FL

Igor Sala
Igor Sala Member Posts: 34 Blue Ribbon
edited Nov 15, 2018 5:53PM in APEX Discussions

Hi folks,

I'm trying to import a page from different App and Workspace but is raising an error:

  • ORA-00001: unique constraint (APEX_050100.WWV_FLOW_PAGE_PLUGS_PK) violated

The command which I'm using is:

begin

    apex_application_install.set_workspace('PRODUCTION');

    apex_application_install.set_application_id(100);

   -- apex_application_install.generate_offset;

    apex_application_install.set_application_alias('APP_PRODUCTION');

end;

/

@/Users/UserX/Documents/Scripts/Apex/Pages/page_7777.sql

Could someone help me? I've been trying to find something in Google and Oracle Forum, but no success.

* Bonus: I would like to read your suggestions about manage Develop and Production environment, dev teams and submit the changes to Production environment.

Thanks.

Igor Sala

Answers