		流程:
	
		创建init.dul,control.txt
	
		抽出数据并导入
		
				cat init.dul 
			
				# My init.dul file
			
				dc_columns = 2000000
			
				dc_tables = 100000
			
				dc_objects = 100000
			
				dc_users = 40
			
				db_block_size = 8k
			
				compatible=10       
			
				export_mode=true
			
				control_file=control.txt
			
				#file=test.dmp
			
				# loader format definitions
			
				# LDR_ENCLOSE_CHAR = "
			
				# LDR_PHYS_REC_SIZE = 81
			
				osd_file_leader_size = 1    
				
						control.txt
					
						select ts#||' '||rfile#||' '||name from v$datafile;
					
						TS#||''||RFILE#||''||NAME
					
						--------------------------------------------------------------------------------
					
						0 1 /oradata/ROCK/datafile/o1_mf_system_b1l15g3g_.dbf
					
						1 2 /oradata/ROCK/datafile/o1_mf_sysaux_b1l16gyq_.dbf
					
						2 3 /oradata/ROCK/datafile/o1_mf_undotbs1_b1l17kvq_.dbf
					
						4 4 /oradata/ROCK/datafile/o1_mf_users_b1l18pkv_.dbf
					
						tips:将上面结果复制并创建control.txt
						
								扫描数据库
							
								./dul
							
								scan database;
							
								exit;
							
								bootstrap unloading
							
								./dul
							
								bootstrap;
							
								exit;
							
								bootstrap generate
							
								./dul
							
								bootstrap generate;
							
								@dict.ddl
							
								exit
							
								导出数据
							
								unload database        --全库导出
							
								unload user rock       --按用户导出
							
								unload table city      --按表导出
							
								DUL> unload user dark;
							
								About to unload DARK's tables ...
							
								. unloading table                      CITY       2 rows unloaded
							
								DUL> 
							
								服务器本机imp导入数据
							
								[oracle@node1 soft]$ imp dark/dark file=DARK_CITY.dmp full=y
							
								Import: Release 11.2.0.4.0 - Production on Sun Dec 1 15:26:25 2013
							
								Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
							
								Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
							
								With the Partitioning, OLAP, Data Mining and Real Application Testing options
							
								Export file created by EXPORT:V07.00.07 via conventional path
							
								Warning: the objects were exported by Bernard's DUL, not by you
							
								. importing Bernard's DUL's objects into DARK
							
								. importing Bernard's DUL's objects into DARK
							
								. . importing table                         "CITY"          2 rows imported
							
								Import terminated successfully without warnings.
							
								验证数据
							
								SQL> select * from city;
							
								 ID CITY
							
								---------- --------------------
							
								 1 a
							
								 2 b
							
								end/
ITPub博客

dul10.2.0.5.25抽取10204数据

最新文章
