dul unexp dmp
$ cat init.dul
osd_big_endian_flag=false
osd_dba_file_bits=10
osd_c_struct_alignment=32
osd_file_leader_size=1
osd_word_size = 32
dc_columns=2000000
dc_tables=10000
dc_objects=1000000
dc_users=400
dc_segments=100000
db_block_size=8192
export_mode=true
compatible=12
Buffer=10485760
DUL> alter session set LDR_OUTPUT_IN_UTF8=TRUE;
DUL> scan dump file expdemo.dmp01;
** 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:
DUL> unexp "LOCATION" ( "ID" NUMBER(3, 0), "DESCR" VARCHAR2(25) ) dump file expdemo.dmp01 from 792800;
$ sqlplus newuser/newuser@ <create table ....>
$ sqlldrnewuser/newuser control=LOCATION.ctl log=loader.log
页:
[1]