Skip to Main Content
Feature Request FR-1582
Product Area Installation and Administration
Status ROADMAP

34 Voters

Export/Import of multiple applications as ZIP file

dominique.denie Public · Oct 21 2020

It would be nice if there is a functionality to export/import all applications of a workspace into a single ZIP file. This is very usefull when we wish to backup our applications

This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • robi OP 3.9 years ago

    I wold like support for this idea, It wold be a great improvement

  • tdoberman OP 3.8 years ago 
    for x in (select application_id from apex_applications
             where WORKSPACE in ('WORKSPACE1', 'WORKSPACE2'))
loop
     sys_export_app(x.application_id, '', '', '', 'BACKUP');
end loop;

    create or replace procedure sys_export_app(p_app_id          in number
                      , p_exp_ir_pub_rep  in varchar2
                      , p_exp_ir_priv_rep in varchar2
                      , p_exp_ir_notif    in varchar2
                      , p_ora_dir         in varchar2) as
 l_clob clob;
 l_file_name varchar2(255);
begin
 l_file_name := 'app' || p_app_id || '_export.sql';
 l_clob := wwv_flow_utilities.export_application_to_clob(p_application_id            => p_app_id
                                                       , p_export_ir_public_reports  => p_exp_ir_pub_rep
                                                       , p_export_ir_private_reports => p_exp_ir_priv_rep
                                                       , p_export_ir_notifications   => p_exp_ir_notif);
 DBMS_XSLPROCESSOR.CLOB2FILE(l_clob, p_ora_dir, l_file_name);
end sys_export_app;

    and from system zip!