Oracle database subsetting

Functionality of Subsetting can be done on Oracle databases.

Subsetting configuration

Oracle database must be specially configured to be a target database in subsetting.

Subsetting table with XMLTYPE data type

When subsetting Oracle database, there are some technical limits for subsetting a table that contains an XMLTYPE data type. To make it possible, two steps need to be taken:

1. User must be granted privilege to create table
2. User must run a 'Create/replace procedure' script in the target database.

'Create/replace procedure' script:

create or replace procedure executeAsUser(PARAM1 IN varchar2)
AUTHID CURRENT_USER IS
BEGIN
    EXECUTE IMMEDIATE PARAM1;
end;