OUD恢复表被TRUNCATE OFFLINE表所在的表空间 生成数据字典.docxVIP

OUD恢复表被TRUNCATEOFFLINE表所在的表空间生成数据字典：unload dict显示表的段头：desc?username.tablename找到实际的data object id： dump datafile?file#?block?block#扫描数据：scan extent恢复表：unload table?username.tablename?object?object_idODU descsys.odu_xffObject ID:53960Storage(Obj#=53960 DataObj#=53960 TS#=7 File#=6 Block#=11 Cluster=0)NO. SEG INT Column Name Null? Type --- --- --- ------------------------------ --------- ------------------------------ 1 1 1 OWNER VARCHAR2(30) 2 2 2 OBJECT_NAME VARCHAR2(128) 3 3 3 SUBOBJECT_NAME VARCHAR2(30) 4 4 4 OBJECT_ID NUMBER 5 5 5 DATA_OBJECT_ID NUMBER 6 6 6 OBJECT_TYPE VARCHAR2(19) 7 7 7 CREATED DATE 8 8 8 LAST_DDL_TIME DATE 9 9 9 TIMESTAMP VARCHAR2(19) 10 10 10 STATUS VARCHAR2(7) 11 11 11 TEMPORARY VARCHAR2(1) 12 12 12 GENERATED VARCHAR2(1) 13 13 13 SECONDARY VARCHAR2(1) ODU dump datafile 6 block 11Block Header:block type=0x23 (ASSM segment header block)block format=0xa2 (oracle 10)blockrdba=0x0180000b (file#=6, block#=11)scn=0x0000.000dcded, seq=3, tail=0xcded2303block checksum value=0x780b=30731, flag=4Data Segment Header: Extent Control Header ------------------------------------------------------------- Extent Header:: extents: 1 blocks: 8last map: 0 #maps: 0 offset: 2716Highwater:: 0x0180000c (rfile#=