V databázi 10g a vyšší byla představena nová utilita a to datová pumpa. Je to nástupce utilit exp a imp. Je rychlejší a má i více voleb. Jedna z nich je i možnost přenášet schémata ve kterých je jeden sloupec zakryptovaný. Nebudu teď zde popisovat veškeré funkce, nehledě na to, že jsem tak učinil v mé knize.

Podívejte se jak provést export schematu SECURE do schematu SECURE_CLONE pomocí data pump.

Export

declare

h1   NUMBER;

begin

h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', job_name => 'EXP', version => 'COMPATIBLE');

dbms_datapump.set_parallel(handle => h1, degree => 1);

dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);

dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''VEROTEL'')');

dbms_datapump.add_file(handle => h1, filename => 'EXPDAT_SECURE_%U.DMP', directory => 'DATA_PUMP_DIR', filetype => 1);

dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);

dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');

dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 'BLOCKS');

dbms_datapump.set_parameter(handle => h1, name => 'ENCRYPTION_PASSWORD', value => 'welcome1');

dbms_datapump.set_parameter(handle => h1, name => 'ENCRYPTION', value => 'ENCRYPTED_COLUMNS_ONLY');

dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);

dbms_datapump.detach(handle => h1);

end;

/

Import

declare
h1   NUMBER;
begin
h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'SCHEMA', job_name => 'IMP', version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.add_file(handle => h1, filename => 'EXPDAT_SECURE_%U.DMP', directory => 'DATA_PUMP_DIR', filetype => 1);
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_SCHEMA', old_value => 'SECURE', value => 'SECURE_CLONE');
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''SECURE'')');
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
dbms_datapump.set_parameter(handle => h1, name => 'ENCRYPTION_PASSWORD', value => 'silne_heslo');
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.detach(handle => h1);
end;
/