摘要：
impdp system/Clic1234 attach=SYS_IMPORT_ILEARN_TRA desc ILEARN_TRA.NOTIFI_TACTIC desc ILEARN_TRA.MSG_MAILdesc ILEARN_TRA.NT_HISTORYdesc ILEARN_TRA.ATTEMPTdesc ILEARN_TRA.NOTIFI_TACTICdesc ILEARN_TRA.... 阅读全文
摘要：
col name for a40 select name,locks,pins from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE'; 10.21.1.20 和10.24.51.11两个数据库的dblibk已经建好了，主要就impdp就可以了，一共需要导出 drop user ILEARN_... 阅读全文
摘要：
select distinct(sql_id),OPNAME,sid,SERIAL# from v$session_longops where sofar != totalwork and time_remaining>0 and OPNAME ='Sort Output'; create table temp_longops as select distinct(sql_id),OPNAME... 阅读全文