闂錛歄RACLE 11g 灝嗘煇鐢ㄦ埛鑷甫琛ㄧ敤 EXP 鍛戒護瀵煎嚭鍐岻MP瀵煎叆 10g 鏃?鍙戠幇絀鴻〃涓嶈兘鍒板鍑?/span>
鍘熷洜錛?1g 寮濮嬪緩琛ㄦ椂錛岄粯璁や笉鍒嗛厤 segment ,浠ヨ妭鐪佺┖闂達紝褰撹〃鎻掑叆絎竴鏉℃暟鎹椂錛屽啀鍒嗛厤 segment
瑙e喅鏂規硶3涓斿緞錛?/span>
1:鍚戠┖鐧芥彃鍏ヤ竴鏉℃暟鎹紝鍐嶅垹闄ゆ帀錛屽氨鍒嗛厤絀洪棿浜嗭紙絀鴻〃姣旇緝灝戯級銆?/span>
2錛氫慨鏀圭郴緇熷弬鏁癮lter system set deferred_segment_create=false;
錛堝浠ュ悗鏂板鐨勮〃緋葷粺浼氬垎閰? segment錛夛紝閲嶅惎鏁版嵁搴撱?/span>
3錛氭壒閲忓鐜版湁鐨勭┖琛ㄥ垎閰嶇┖闂?/span>
select 'alter table ' || table_name || ' allocate extent;' as sql from all_tables where num_rows = 0 and OWNER=username ;
鎵ц瀵煎叆瀵煎嚭宸ヤ綔
1. exp system/managerr@servicename owner=username1 file=expfile.dmp full=y
2. imp ystem/manager@servicename fromuser=username1 touser=username2 ignore=y file=expfile.dmp full=y

]]>