keep_master  export/importtan sonra datapump master tablosunun silinmesini engeller ve metrics db objelerin ne kadar süre export/import edildiğinin bilgisini toplar.

 

expdp 'userid="/ as sysdba"' DIRECTORY=EXP_DIR dumpfile=ordba.dmp schemas=ordba logfile=ordba_exp.log job_name=ordba_EXP KEEP_MASTER=y metrics=y
impdp 'userid="/ as sysdba"' DIRECTORY=EXP_DIR dumpfile=ordba.dmp schemas=ordba logfile=ordba_imp.log remap_schema=ordba:FBDENEME job_name=ordba_IMP KEEP_MASTER=y metrics=y
select * from SYS.ordba_EXP;

select * from SYS.ordba_IMP;
select 
 tab_owner, 
 tab_name, 
 completed_rows, 
 tab_size, 
 elapsed_time 
from (select 
 base_object_schema,
 object_name, 
 (lag(object_name, 1) over(order by process_order)) as TAB_NAME,
 (lag(base_object_schema, 1) over(order by process_order)) as TAB_OWNER, 
 completed_rows, 
 (dump_length / (1024 * 1024 * 1024)) || ' GB' TAB_SIZE, 
 elapsed_time 
 from 
 sys.ordba_IMP
 where 
 object_type_path = 'SCHEMA_EXPORT/TABLE/TABLE_DATA' and 
 process_order >= 1
 ) 
where 
 object_name is null
 order by elapsed_time desc;


Reklamlar