This content has been marked as final. Show 6 replies
To Export: go to the page, click utilities, click export. Follow the wizard.
To import: go to the application in production, click export/immort. Follow the wizard.
you can export page from one application and modify line in export script:
Modify APP_NUMBER with number off application where are you importing script but you'll probably have problems with constraints.
wwv_flow.g_flow_id := nvl(wwv_flow_application_install.get_application_id,APP_NUMBER );
The best way would be to separate workspaces. One for development, one for production version (copy of dev) and put them on different instances of APEX. Then you could easily do export/import.
Problem is that both apps are in same workspace and instance of APEX, if I got it right.
OK I exported the page, changed the application id to Production, and then tried importing. You're right, I received a unique constraint error. Is there any way around this? Do I simply have to delete the page from Production and then import the updated page?
I don't think you can do that, even if you delete the page, but you can try, just backup your application before you do.
The best way to do updates if your stuck with the same workspace and environment is using build options. That way you can work on multiple update at a time, such as you are probably doing now. You can basically bind a build option to every change you make, and then decide whether or not you want to include it in your export.
More about build options can be found here:
Actually deleting the page and copying does in fact work. It's a little nerve-wracking doing that on Prod, but I'm not sure what other option I have at this point. Everything else I've tried has not worked. You just have to ensure when you're copying the page back to the target you reuse all necessary supporting templates, lists, etc.