Získejte konzultaci v hodnotě 1 500 Kč k vaší databázi Oracle zcela zdarma. Ozvěte se mi ještě dnes.

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;/



Komentáře