APEX 4.0 : how to copy page from one application to another application in APEX -
please me how copy page existing application of apex work space of apex application.
you can't out of box.
beside workspace ids, application id matters. if have 2 different workspaces , same application in different ids, further complicates things.
export complete application, import use different id don't overwrite existing one, , create new page copy of newly imported application's page.
antoher way edit exported page sql file but, let me stress this, this not recommended. , graciously stated in otn forums , again, if you'd require support application/apex issue , find messing around in sql files you'd not support there. only when understand , know you're do! if alter code without understanding doing in far worse situation 1 started in. other case, follow application export/import/copy line.
anyway, in position workspace ids differed application ids not. in case altering exported file quite trivial , requires editing 1 (one) line , concerns piece of code:
begin -- assumes running script connected sql*plus oracle user apex_040200 or owner (parsing schema) of application. wwv_flow_api.set_security_group_id(p_security_group_id=>nvl(wwv_flow_application_install.get_workspace_id,27000294100083787867)); end; /
this 1 of first pieces of code in exported page file. can see, workspace id set here. if attempted imported application (even if app id matches 1 you're trying import to) you'd error. change id 1 matching workspace , it'll work. of course, need know workspace ids, , can find these executing select on apex environment(s?)
select workspace, workspace_display_name, workspace_id apex_workspaces
some advice:
if you're still in start-up phase of apex installation, might want make sure workspace ids identical. example, test , production environment having identical workspace , application ids interesting. you'd have 2 instances (2 database installations on 2 different servers), want ids same.
make sure of this, can export workspace 1 environment , import other one. can instance administration in apex, ie internal workspace.
Comments
Post a Comment