Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Igor SalaNov 14 2018 — edited Nov 15 2018

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.

Comments
Post Details
Added on Nov 14 2018
7 comments
3,154 views