8.5 ADD_DATA_REPORTER_REMAP Procedure

This procedure remaps a data reporter object owner when importing a dataset or reporting app.

Syntax

PROCEDURE apex_application_install.add_data_reporter_remap (
    p_schema_from    IN   VARCHAR2,
    p_schema_to      IN   VARCHAR2 );

Parameters

Parameter	Description
p_schema_from	The source schema to map from.
p_schema_to	The target schema we are mapping to.

Example

The following example demonstrates how to remap data reporter objects owned by HR to the DEMO scheme and objects owned by SALES to the PROJECTS schema.

begin
    apex_application_install.set_workspace('EXAMPLE');
    apex_application_install.add_data_reporter_remap ( 'HR', 'DEMO' );
    apex_application_install.add_data_reporter_remap ( 'SALES', 'PROJECTS' );
end;
@dr_dataset_example.sql