dul unexp dmp

admin

1. [oracle@vm1 dul]$ cat init.dul
   
2. osd_big_endian_flag=false
   
3. osd_dba_file_bits=10
   
4. osd_c_struct_alignment=32
   
5. osd_file_leader_size=1
   
6. osd_word_size = 32
   
7. dc_columns=2000000
   
8. dc_tables=10000
   
9. dc_objects=1000000
   
10. dc_users=400
    
11. dc_segments=100000
    
12. db_block_size=8192
    
13. export_mode=true
    
14. compatible=12
    
15. Buffer=10485760
    

复制代码

1. DUL> alter session set LDR_OUTPUT_IN_UTF8=TRUE;
   
2. DUL> scan dump file expdemo.dmp01;
   
3. ** view dul.log file, search for (CREATE TABLE “<tablename>”). Copy and past table structure, then search for (start of table data) and copy the number shown at the beginning of the line and past it in the unexp command:
   
4. DUL> unexp "LOCATION" ( "ID" NUMBER(3, 0), "DESCR" VARCHAR2(25) ) dump file expdemo.dmp01 from 792800;
   

复制代码

1. $ sqlplus newuser/newuser  @ <create table ....>
   
2. $ sqlldr  newuser/newuser control=LOCATION.ctl log=loader.log
   

复制代码