oracle

drop 表恢复 思路： 首先要知道做了什么， 基表做了删除需要插入回去，L1 L2 L3 extend 之类的做了个修改要修改回去 获取segment 信息 set linesize 200 pagesize 200 col owner for a10 col segment_name for a10 select owner,segment_name,header_file,header_block,SEGMENT_TYPE from dba_segments where owner='ZC' and  segment_name='TEST111'; OWNER    SEGMENT_NA HEADER_FILE HEADER_BLOCK SEGMENT_TYPE ---------- ---------- ----------- ------------ ------------------ ZC    TEST111        27    130 TABLE 获取对象信息 set linesize 200 pagesize 9999 col owner for a10 col object_name for a20 select owner,object_name,OBJECT_ID,DATA_OBJECT_ID from dba_objects where  owner='ZC' and   object_name='TEST111'; OWNER    OBJECT_NAME OBJECT_ID DATA_OBJECT_ID ---------- -------------------- ---------- -------------- ZC    TEST111      73948     73948 获取 block 信息 set linesize 200 pagesize 999 col OWNER for a10 col segment_name for a60 select OWNER,segment_name,extent_id,file_id,block_id,blocks from dba_extents  where  owner='ZC' and  segment_name ='TEST111' order by extent_id; OWNER    SEGMENT_NAME                          EXTENT_ID    FILE_ID BLOCK_ID     BLOCKS ---------- ------------------------------------------------------------ ---------- ---------- ---------- ---------- ZC        TEST111                                     0    27      128   8 ZC        TEST111                                     1    27      136   8 ZC        TEST111                                     2    27      144   8 ZC        TEST111                                     3    27      152   8 ZC        TEST111                                     4    27      160   8 ZC        TEST111                                     5    27      168   8 ZC        TEST111                                     6    27      176   8 ZC        TEST111                                     7    27      184   8 ZC        TEST111                                     8    27      192   8 ZC        TEST111                                     9    27      200   8 ZC        TEST111                                     10    27      208   8 ZC        TEST111                                     11    27      216   8 ZC        TEST111                                     12    27      224   8 ZC        TEST111                                     13    27      232   8 ZC        TEST111                                     14    27      240   8 ZC        TEST111                                     15    27      248   8 ZC        TEST111                                     16    27      256 128 ZC        TEST111                                     17    27      384 128 ...                                                                          ZC        TEST111                                     78    27     8192 128 ZC        TEST111                                     79    27     8320       1024 ZC        TEST111                                     80    27     9344       1024 ZC        TEST111                                     81    27    10368       1024 alter session set tracefile_identifier='test111_before_drop'; oradebug setmypid alter system dump datafile 27 block 130; oradebug close_trace oradebug tracefile_name 段头块是L3 记录了所有L2  L2又记录了L1 dump L2 alter session set tracefile_identifier='test111-L2_before_drop'; oradebug setmypid alter system dump datafile 27 block 129; oradebug close_trace oradebug tracefile_name dump L1 alter session set tracefile_identifier='test111-L1_before_drop'; oradebug setmypid alter system dump datafile 27 block 128; oradebug close_trace oradebug tracefile_name   bbed恢复extent map 这一步有问题， ora_rdba [oracle@sourcedb ~]$ ora_rdba 0x014f8088 Welcome to use ora_rdba tool authored by orastar. weixin: xidoublestar rdba is: 0x14f8088 datafile# is: 5 datablock is: 1015944 dump command:alter system dump datafile 5 block 1015944; [oracle@sourcedb ~]$ 应该能梳理出步骤来 unsigned int rfn  = rdba>>22;     unsigned int blk  = (rdba<<10)>>10;     printf("rdba is: %#08x\n",rdba);     printf("datafile# is: %d\n",rfn);     printf("datablock is: %d\n",blk);     printf("dump command:alter system dump datafile %d block %d;\n",rfn,blk); gcc rdba.c -o rdba 这里用的是L2 grep -w 'Inst' orcl_ora_4828_test111-L2_before_drop.trc|awk '{print $1}'|xargs -n 1 ora_rdba|grep command|sed 's/dump command://g' alter session set tracefile_identifier='test111-L2_after_drop2'; oradebug setmypid alter system dump datafile 27 block 128; alter system dump datafile 27 block 144; alter system dump datafile 27 block 160; alter system dump datafile 27 block 176; alter system dump datafile 27 block 192; alter system dump datafile 27 block 208; alter system dump datafile 27 block 224; alter system dump datafile 27 block 240; alter system dump datafile 27 block 256; alter system dump datafile 27 block 257; alter system dump datafile 27 block 384; alter system dump datafile 27 block 385; alter system dump datafile 27 block 512; alter system dump datafile 27 block 513; alter system dump datafile 27 block 640; alter system dump datafile 27 block 641; alter system dump datafile 27 block 768; alter system dump datafile 27 block 769; alter system dump datafile 27 block 896; alter system dump datafile 27 block 897; alter system dump datafile 27 block 1024; alter system dump datafile 27 block 1025; alter system dump datafile 27 block 1152; alter system dump datafile 27 block 1153; alter system dump datafile 27 block 1280; alter system dump datafile 27 block 1281; alter system dump datafile 27 block 1408; alter system dump datafile 27 block 1409; alter system dump datafile 27 block 1536; alter system dump datafile 27 block 1537; alter system dump datafile 27 block 1664; alter system dump datafile 27 block 1665; alter system dump datafile 27 block 1792; alter system dump datafile 27 block 1793; alter system dump datafile 27 block 1920; alter system dump datafile 27 block 1921; alter system dump datafile 27 block 2048; alter system dump datafile 27 block 2049; alter system dump datafile 27 block 2176; alter system dump datafile 27 block 2177; alter system dump datafile 27 block 2304; alter system dump datafile 27 block 2305; alter system dump datafile 27 block 2432; alter system dump datafile 27 block 2433; alter system dump datafile 27 block 2560; alter system dump datafile 27 block 2561; alter system dump datafile 27 block 2688; alter system dump datafile 27 block 2689; alter system dump datafile 27 block 2816; alter system dump datafile 27 block 2817; alter system dump datafile 27 block 2944; alter system dump datafile 27 block 2945; alter system dump datafile 27 block 3072; alter system dump datafile 27 block 3073; alter system dump datafile 27 block 3200; alter system dump datafile 27 block 3201; alter system dump datafile 27 block 3328; alter system dump datafile 27 block 3329; alter system dump datafile 27 block 3456; alter system dump datafile 27 block 3457; alter system dump datafile 27 block 3584; alter system dump datafile 27 block 3585; alter system dump datafile 27 block 3712; alter system dump datafile 27 block 3713; alter system dump datafile 27 block 3840; alter system dump datafile 27 block 3841; alter system dump datafile 27 block 3968; alter system dump datafile 27 block 3969; alter system dump datafile 27 block 4096; alter system dump datafile 27 block 4097; alter system dump datafile 27 block 4224; alter system dump datafile 27 block 4225; alter system dump datafile 27 block 4352; alter system dump datafile 27 block 4353; alter system dump datafile 27 block 4480; alter system dump datafile 27 block 4481; alter system dump datafile 27 block 4608; alter system dump datafile 27 block 4609; alter system dump datafile 27 block 4736; alter system dump datafile 27 block 4737; alter system dump datafile 27 block 4864; alter system dump datafile 27 block 4865; alter system dump datafile 27 block 4992; alter system dump datafile 27 block 4993; alter system dump datafile 27 block 5120; alter system dump datafile 27 block 5121; alter system dump datafile 27 block 5248; alter system dump datafile 27 block 5249; alter system dump datafile 27 block 5376; alter system dump datafile 27 block 5377; alter system dump datafile 27 block 5504; alter system dump datafile 27 block 5505; alter system dump datafile 27 block 5632; alter system dump datafile 27 block 5633; alter system dump datafile 27 block 5760; alter system dump datafile 27 block 5761; alter system dump datafile 27 block 5888; alter system dump datafile 27 block 5889; alter system dump datafile 27 block 6016; alter system dump datafile 27 block 6017; alter system dump datafile 27 block 6144; alter system dump datafile 27 block 6145; alter system dump datafile 27 block 6272; alter system dump datafile 27 block 6273; alter system dump datafile 27 block 6400; alter system dump datafile 27 block 6401; alter system dump datafile 27 block 6528; alter system dump datafile 27 block 6529; alter system dump datafile 27 block 6656; alter system dump datafile 27 block 6657; alter system dump datafile 27 block 6784; alter system dump datafile 27 block 6785; alter system dump datafile 27 block 6912; alter system dump datafile 27 block 6913; alter system dump datafile 27 block 7040; alter system dump datafile 27 block 7041; alter system dump datafile 27 block 7168; alter system dump datafile 27 block 7169; alter system dump datafile 27 block 7296; alter system dump datafile 27 block 7297; alter system dump datafile 27 block 7424; alter system dump datafile 27 block 7425; alter system dump datafile 27 block 7552; alter system dump datafile 27 block 7553; alter system dump datafile 27 block 7680; alter system dump datafile 27 block 7681; alter system dump datafile 27 block 7808; alter system dump datafile 27 block 7809; alter system dump datafile 27 block 7936; alter system dump datafile 27 block 7937; alter system dump datafile 27 block 8064; alter system dump datafile 27 block 8065; alter system dump datafile 27 block 8192; alter system dump datafile 27 block 8320; alter system dump datafile 27 block 8321; alter system dump datafile 27 block 8322; alter system dump datafile 27 block 8323; alter system dump datafile 27 block 9344; alter system dump datafile 27 block 9345; alter system dump datafile 27 block 9346; alter system dump datafile 27 block 9347; alter system dump datafile 27 block 10368; alter system dump datafile 27 block 10369; alter system dump datafile 27 block 10370; alter system dump datafile 27 block 10371; oradebug close_trace oradebug tracefile_name /u02/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5286_test111-L2_after_drop2.trc grep -i 'Length:' /u02/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5286_test111-L2_after_drop2.trc|grep -in 'Offset:'|sed 's/://g'|sed 's/0x//g'|awk '{print "select "$1 " as n_num,\47" $2 "\47 as n_dba," $4 " as n_len from dual union all"}' 按照文档测试 create table zc.drop_1(c_char1 char(10),c_char2 char(10)) tablespace zc; begin for i in 1 .. 1000000 loop insert into zc.drop_1 values(i,'heluhun'); end loop; commit; end; / alter system flush shared_pool; alter system flush shared_pool; alter system flush buffer_cache; alter system flush buffer_cache; select count(1) from zc.drop_1;  我 set linesize 200 pagesize 200 col owner for a10 col segment_name for a10 select owner,segment_name,header_file,header_block,SEGMENT_TYPE from dba_segments where segment_name='DROP_1'; OWNER    SEGMENT_NA HEADER_FILE HEADER_BLOCK SEGMENT_TYPE ---------- ---------- ----------- ------------ ------------------ ZC    DROP_1        28 11394 TABLE set linesize 200 pagesize 9999 col owner for a10 col object_name for a20 select owner,object_name,OBJECT_ID,DATA_OBJECT_ID from dba_objects where object_name='DROP_1'; OWNER    OBJECT_NAME OBJECT_ID DATA_OBJECT_ID ---------- -------------------- ---------- -------------- ZC             DROP_1      73979     73979 set linesize 200 pagesize 999 col OWNER for a10 col segment_name for a20 select OWNER,segment_name,extent_id,file_id,block_id,blocks from dba_extents where segment_name ='DROP_1' order by extent_id; OWNER    SEGMENT_NAME EXTENT_ID    FILE_ID BLOCK_ID     BLOCKS ---------- -------------------- ---------- ---------- ---------- ---------- ZC    DROP_1 0    28    11392   8 ZC    DROP_1 1    28    11400   8 ZC    DROP_1 2    28    11408   8 *** ZC    DROP_1 92    28    32896       1024 4. 在线日志查询 set linesize 200 pagesize 9999  col MEMBER for a50 COL IS_RECOVERY_DEST_FILE FOR A30 col ARCHIVED for a10 col file_name for a60 col STATUS for a10 select g.group#,g.thread#,g.SEQUENCE#,g.bytes,g.members,g.ARCHIVED,g.STATUS,member   from v$log g,v$logfile f  where g.group#=f.group#;     GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARCHIVED   STATUS     MEMBER ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------------------------- 3     1       48  209715200      1 YES   ACTIVE     /u02/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_md632cg0_.log 2     1       50  209715200      1 NO   CURRENT    /u02/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_md632c6d_.log 1     1       49  209715200      1 YES   ACTIVE     /u02/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_md632c1z_.log drop table zc.drop_1 purge; alter system archive log current; Step 1   Determine which redo log file was most recently archived by the database. set line 200 col name for a80 SELECT NAME, SEQUENCE# FROM V$ARCHIVED_LOG WHERE FIRST_TIME = (SELECT MAX(FIRST_TIME) FROM V$ARCHIVED_LOG); Step 2   Ensure that you have a complete list of redo log files. SELECT NAME FROM V$ARCHIVED_LOG    WHERE SEQUENCE# >= 49 AND SEQUENCE# <= 50    ORDER BY SEQUENCE# ASC; Step 3   Specify the list of the redo log files of interest. EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/u02/app/oracle/product/19.9.0/db_1/dbs/arch1_49_1177527885.dbf', OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/u02/app/oracle/product/19.9.0/db_1/dbs/arch1_50_1177527885.dbf',OPTIONS => DBMS_LOGMNR.ADDFILE);       Step 4   Start LogMiner.    EXECUTE DBMS_LOGMNR.START_LOGMNR(-    OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + -               DBMS_LOGMNR.COMMITTED_DATA_ONLY);                 Step 5   Query the V$LOGMNR_CONTENTS view. set linesize 3000 set pagesize 2000 col USR for a10 col sql_redo for a50 col SQL_UNDO for a50 COL OPERATION FOR A20 SELECT to_char(TIMESTAMP,'yyyy-mm-dd hh24:mi:ss') t_time,USERNAME AS usr,SQL_REDO,SQL_UNDO,OPERATION FROM      V$LOGMNR_CONTENTS    WHERE  TABLE_NAME in ('DROP_1','SEG$','OBJ$','TAB$','COL$');    --and OPERATION in ('DELETE','INSERT');             Step 6   End the LogMiner session. EXECUTE DBMS_LOGMNR.END_LOGMNR();  SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/arch1/1_44_1042492403.dbf', OPTIONS => DBMS_LOGMNR.NEW); PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(-    OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + -               DBMS_LOGMNR.COMMITTED_DATA_ONLY); > >  PL/SQL procedure successfully completed. SQL> SQL> set linesize 3000 set pagesize 2000 col USR for a10 col sql_redo for a50 col SQL_UNDO for a50 COL OPERATION FOR A20 SELECT to_char(TIMESTAMP,'yyyy-mm-dd hh24:mi:ss') t_time,USERNAME AS usr,SQL_REDO,SQL_UNDO,OPERATION FROM      V$LOGMNR_CONTENTS    WHERE  TABLE_NAME in ('DROP_1','SEG$','OBJ$','TAB$','COL$'); T_TIME     USR        SQL_REDO   SQL_UNDO      OPERATION ------------------- ---------- -------------------------------------------------- -------------------------------------------------- -------------------- 2024-08-22 21:36:55 SYS        drop table zc.drop_1 purge;      DDL 2024-08-22 21:36:55 SYS        delete from "SYS"."COL$" where "OBJ#" = '73979' an insert into "SYS"."COL$"("OBJ#","COL#","SEGCOL#"," DELETE        d "COL#" = '1' and "SEGCOL#" = '1' and "SEGCOLLENG SEGCOLLENGTH","OFFSET","NAME","TYPE#","LENGTH","FI        TH" = '10' and "OFFSET" = '0' and "NAME" = 'C_CHAR XEDSTORAGE","PRECISION#","SCALE","NULL$","DEFLENGT delete obj#: 13863,DATAOBJ: 13863 timestamp: 2020-06-21 07:33:08 sql undo  insert into "SYS"."COL$"("OBJ#","COL#","SEGCOL#","SEGCOLLENGTH","OFFSET","NAME","TYPE#","LENGTH","FIXEDSTORAGE","PRECISION#","SCALE","NULL$","DEFLENGTH","DEFAULT$","INTCOL#","PROPERTY","CHARSETID","CHARSETFORM","EVALEDITION#","UNUSABLEBEFORE#","UNUSABLEBEGINNING#","SPARE1","SPARE2","SPARE3","SPARE4","SPARE5","SPARE6","SPARE7","SPARE8","COLLID","COLLINTCOL#","SPARE9","SPARE10","SPARE11","SPARE12","SPARE13","ACDRRESCOL#") values ('73979','1','1','10','0','C_CHAR1','96','10','0',NULL,NULL,'0',NULL,NULL,'1','0','873','1','0',NULL,NULL,'0','0','10',NULL,NULL,NULL,NULL,NULL,'16382',NULL,'0','0',NULL,NULL,NULL,NULL); insert into "SYS"."COL$"("OBJ#","COL#","SEGCOL#","SEGCOLLENGTH","OFFSET","NAME","TYPE#","LENGTH","FIXEDSTORAGE","PRECISION#","SCALE","NULL$","DEFLENGTH","DEFAULT$","INTCOL#","PROPERTY","CHARSETID","CHARSETFORM","EVALEDITION#","UNUSABLEBEFORE#","UNUSABLEBEGINNING#","SPARE1","SPARE2","SPARE3","SPARE4","SPARE5","SPARE6","SPARE7","SPARE8","COLLID","COLLINTCOL#","SPARE9","SPARE10","SPARE11","SPARE12","SPARE13","ACDRRESCOL#") values ('73979','2','2','10','0','C_CHAR2','96','10','0',NULL,NULL,'0',NULL,NULL,'2','0','873','1','0',NULL,NULL,'0','0','10',NULL,NULL,NULL,NULL,NULL,'16382',NULL,'0','0',NULL,NULL,NULL,NULL); insert into "SYS"."TAB$"("OBJ#","DATAOBJ#","TS#","FILE#","BLOCK#","BOBJ#","TAB#","COLS","CLUCOLS","PCTFREE$","PCTUSED$","INITRANS","MAXTRANS","FLAGS","AUDIT$","ROWCNT","BLKCNT","EMPCNT","AVGSPC","CHNCNT","AVGRLN","AVGSPC_FLB","FLBCNT","ANALYZETIME","SAMPLESIZE","DEGREE","INSTANCES","INTCOLS","KERNELCOLS","PROPERTY","TRIGFLAG","SPARE1","SPARE2","SPARE3","SPARE4","SPARE5","SPARE6","SPARE7","SPARE8","SPARE9","SPARE10","ACDRFLAGS","ACDRTSOBJ#","ACDRDEFAULTTIME","ACDRROWTSINTCOL#") values ('73979','73979','6','28','11394',NULL,NULL,'2',NULL,'10','40','1','255','1073741825','--------------------------------------',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','2','536870912','0','736',NULL,NULL,NULL,NULL,TO_DATE('23-AUG-24', 'DD-MON-RR'),NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'); insert into "SYS"."OBJ$"("OBJ#","DATAOBJ#","OWNER#","NAME","NAMESPACE","SUBNAME","TYPE#","CTIME","MTIME","STIME","STATUS","REMOTEOWNER","LINKNAME","FLAGS","OID$","SPARE1","SPARE2","SPARE3","SPARE4","SPARE5","SPARE6","SIGNATURE","SPARE7","SPARE8","SPARE9","DFLCOLLID","CREAPPID","CREVERID","CREPATCHID","MODAPPID","MODVERID","MODPATCHID","SPARE10","SPARE11","SPARE12","SPARE13","SPARE14") values ('73979','73979','109','DROP_1','1',NULL,'2',TO_DATE('22-AUG-24', 'DD-MON-RR'),TO_DATE('22-AUG-24', 'DD-MON-RR'),TO_DATE('22-AUG-24', 'DD-MON-RR'),'1',NULL,NULL,'0',NULL,'6','1','109',NULL,NULL,NULL,HEXTORAW('0690948ea6c96f0c5eaf3ad8760882cf'),'0','0','0','16382',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); update "SYS"."SEG$" set "TYPE#" = '5', "BLOCKS" = '22528', "EXTENTS" = '93', "INIEXTS" = '8', "MINEXTS" = '1', "MAXEXTS" = '2147483645', "EXTSIZE" = '128', "EXTPCT" = '0', "USER#" = '109', "LISTS" = '0', "GROUPS" = '0', "BITMAPRANGES" = '2147483645', "CACHEHINT" = '0', "SCANHINT" = '0', "HWMINCR" = '73979', "SPARE1" = '4325633' where "FILE#" = '28' and "BLOCK#" = '11394' and "TYPE#" = '3' and "TS#" = '6' and "BLOCKS" = '22528' and "EXTENTS" = '93' and "INIEXTS" = '8' and "MINEXTS" = '1' and "MAXEXTS" = '2147483645' and "EXTSIZE" = '128' and "EXTPCT" = '0' and "USER#" = '109' and "LISTS" = '93393135' and "GROUPS" = '0' and "BITMAPRANGES" = '2147483645' and "CACHEHINT" = '0' and "SCANHINT" = '0' and "HWMINCR" = '73979' and "SPARE1" = '4358401' and "SPARE2" IS NULL and ROWID = 'AAAAAIAABAAAH4NAAN'; update "SYS"."SEG$" set "TYPE#" = '3', "BLOCKS" = '22528', "EXTENTS" = '93', "INIEXTS" = '8', "MINEXTS" = '1', "MAXEXTS" = '2147483645', "EXTSIZE" = '128', "EXTPCT" = '0', "USER#" = '109', "LISTS" = '93393135', "GROUPS" = '0', "BITMAPRANGES" = '2147483645', "CACHEHINT" = '0', "SCANHINT" = '0', "HWMINCR" = '73979', "SPARE1" = '4358401' where "FILE#" = '28' and "BLOCK#" = '11394' and "TYPE#" = '3' and "TS#" = '6' and "BLOCKS" = '22528' and "EXTENTS" = '93' and "INIEXTS" = '8' and "MINEXTS" = '1' and "MAXEXTS" = '2147483645' and "EXTSIZE" = '128' and "EXTPCT" = '0' and "USER#" = '109' and "LISTS" = '93393135' and "GROUPS" = '0' and "BITMAPRANGES" = '2147483645' and "CACHEHINT" = '0' and "SCANHINT" = '0' and "HWMINCR" = '73979' and "SPARE1" = '4358465' and "SPARE2" IS NULL and ROWID = 'AAAAAIAABAAAH4NAAN'; insert into "SYS"."SEG$"("FILE#","BLOCK#","TYPE#","TS#","BLOCKS","EXTENTS","INIEXTS","MINEXTS","MAXEXTS","EXTSIZE","EXTPCT","USER#","LISTS","GROUPS","BITMAPRANGES","CACHEHINT","SCANHINT","HWMINCR","SPARE1","SPARE2") values ('28','11394','3','6','22528','93','8','1','2147483645','128','0','109','93393135','0','2147483645','0','0','73979','4358465',NULL); 两条update 没成功 这里恢复的话要从下往上，应该是先 insert SEG$然后再update，另外不能用rowid 进行更新， select count(1) from zc.drop_1;  select count(*) from seg$ where HWMINCR=73979; select count(*) from obj$ where DATAOBJ#=73979; select count(*) from tab$ where DATAOBJ#=73979; select count(*) from col$ where OBJ#=73979; select * from seg$ AS OF timestamp  to_timestamp ('2024-08-22 12:39:07','yyyy-mm-dd hh24:mi:ss') where HWMINCR=73979; select * from obj$ AS OF timestamp  to_timestamp ('2024-08-22 12:39:07','yyyy-mm-dd hh24:mi:ss') where DATAOBJ#=73979; select * from tab$ AS OF timestamp  to_timestamp ('2024-08-22 12:39:07','yyyy-mm-dd hh24:mi:ss') where DATAOBJ#=73979; select * from col$ AS OF timestamp  to_timestamp ('2024-08-22 12:39:07','yyyy-mm-dd hh24:mi:ss') where OBJ#=73979; set linesize 200 pagesize 999 col OWNER for a10 col segment_name for a20 select OWNER,segment_name,extent_id,file_id,block_id,blocks from dba_extents where segment_name ='DROP_1' order by extent_id; 查询结果为空， BBED> set dba 5,130 DBA            0x01400082 (20971650 5,130) BBED> d offset 276 count 12  File: /data2/enmo/hsql01.dbf (5)  Block: 130              Offsets:  276 to  287           Dba:0x01400082 ------------------------------------------------------------------------  00000012 80004001 08000000   <32 bytes per line> BBED> m /x 00000010 offset 276  File: /data2/enmo/hsql01.dbf (5)  Block: 130              Offsets:  276 to  287           Dba:0x01400082 ------------------------------------------------------------------------  00000010 80004001 08000000   <32 bytes per line> BBED> sum apply Check value for File 5, Block 130: current = 0x951b, required = 0x951b BBED> alter system flush shared_pool; alter system flush shared_pool; alter system flush buffer_cache; alter system flush buffer_cache; select count(1) from zc.drop_1;  set linesize 200 pagesize 999 col OWNER for a10 col segment_name for a20 select OWNER,segment_name,extent_id,file_id,block_id,blocks from dba_extents where segment_name ='DROP_1' order by extent_id; extend 名字不对 1 ZC 28.11394 0 28 11392 8 查出来是数据文件名加数据块名字 先不管 先继续 alter session set tracefile_identifier='L2_a_drop'; oradebug setmypid alter system dump datafile 28 block 11394; oradebug close_trace oradebug tracefile_name dump segment header  就可以找到L2的块位置  alter system dump datafile 28 block 11394;    Second Level Bitmap block DBAs     --------------------------------------------------------    DBA 1:   0x07002c81 [oracle@localhost ~]$ ora_rdba  0x07002c81 *******Welcome to use ora_rdba tool authored by orastar.******* *******weixin: xidoublestar******* rdba is: 0x7002c81 datafile# is: 28 datablock is: 11393 dump command:alter system dump datafile 28 block 11393; 这里要dump  L2 块，根据上面的步骤找到  alter session set tracefile_identifier='L2_a_drop'; oradebug setmypid alter system dump datafile 28 block 11393; oradebug close_trace oradebug tracefile_name 找到trace的位置 /u02/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5286_L2_a_drop.trc  根据这个文件找到 dump L1 的语句 grep -w 'Inst' /u02/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5286_L2_a_drop.trc|awk '{print $1}'|xargs -n 1 ora_rdba|grep command|sed 's/dump command://g' 输出： alter system dump datafile 28 block 11392; alter system dump datafile 28 block 11408; alter system dump datafile 28 block 11424; alter system dump datafile 28 block 11440; alter system dump datafile 28 block 11456; alter system dump datafile 28 block 11472; alter system dump datafile 28 block 11488; alter system dump datafile 28 block 11504; alter system dump datafile 28 block 11520; alter system dump datafile 28 block 11521; alter system dump datafile 28 block 11648; alter system dump datafile 28 block 11649; alter system dump datafile 28 block 11776; alter system dump datafile 28 block 11777; alter system dump datafile 28 block 11904; alter system dump datafile 28 block 11905; alter system dump datafile 28 block 12032; alter system dump datafile 28 block 12033; alter system dump datafile 28 block 12160; alter system dump datafile 28 block 12161; alter system dump datafile 28 block 12288; alter system dump datafile 28 block 12289; alter system dump datafile 28 block 12416; alter system dump datafile 28 block 12417; alter system dump datafile 28 block 12544; alter system dump datafile 28 block 12545; alter system dump datafile 28 block 12672; alter system dump datafile 28 block 12673; alter system dump datafile 28 block 12800; alter system dump datafile 28 block 12801; alter system dump datafile 28 block 12928; alter system dump datafile 28 block 12929; alter system dump datafile 28 block 13056; alter system dump datafile 28 block 13057; alter system dump datafile 28 block 13184; alter system dump datafile 28 block 13185; alter system dump datafile 28 block 13312; alter system dump datafile 28 block 13313; alter system dump datafile 28 block 13440; alter system dump datafile 28 block 13441; alter system dump datafile 28 block 13568; alter system dump datafile 28 block 13569; alter system dump datafile 28 block 13696; alter system dump datafile 28 block 13697; alter system dump datafile 28 block 13824; alter system dump datafile 28 block 13825; alter system dump datafile 28 block 13952; alter system dump datafile 28 block 13953; alter system dump datafile 28 block 14080; alter system dump datafile 28 block 14081; alter system dump datafile 28 block 14208; alter system dump datafile 28 block 14209; alter system dump datafile 28 block 14336; alter system dump datafile 28 block 14337; alter system dump datafile 28 block 14464; alter system dump datafile 28 block 14465; alter system dump datafile 28 block 14592; alter system dump datafile 28 block 14593; alter system dump datafile 28 block 14720; alter system dump datafile 28 block 14721; alter system dump datafile 28 block 14848; alter system dump datafile 28 block 14849; alter system dump datafile 28 block 14976; alter system dump datafile 28 block 14977; alter system dump datafile 28 block 15104; alter system dump datafile 28 block 15105; alter system dump datafile 28 block 15232; alter system dump datafile 28 block 15233; alter system dump datafile 28 block 15360; alter system dump datafile 28 block 15361; alter system dump datafile 28 block 15488; alter system dump datafile 28 block 15489; alter system dump datafile 28 block 15616; alter system dump datafile 28 block 15617; alter system dump datafile 28 block 15744; alter system dump datafile 28 block 15745; alter system dump datafile 28 block 15872; alter system dump datafile 28 block 15873; alter system dump datafile 28 block 16000; alter system dump datafile 28 block 16001; alter system dump datafile 28 block 16128; alter system dump datafile 28 block 16129; alter system dump datafile 28 block 16256; alter system dump datafile 28 block 16257; alter system dump datafile 28 block 16384; alter system dump datafile 28 block 16385; alter system dump datafile 28 block 16512; alter system dump datafile 28 block 16513; alter system dump datafile 28 block 16640; alter system dump datafile 28 block 16641; alter system dump datafile 28 block 16768; alter system dump datafile 28 block 16769; alter system dump datafile 28 block 16896; alter system dump datafile 28 block 16897; alter system dump datafile 28 block 17024; alter system dump datafile 28 block 17025; alter system dump datafile 28 block 17152; alter system dump datafile 28 block 17153; alter system dump datafile 28 block 17280; alter system dump datafile 28 block 17281; alter system dump datafile 28 block 17408; alter system dump datafile 28 block 17409; alter system dump datafile 28 block 17536; alter system dump datafile 28 block 17537; alter system dump datafile 28 block 17664; alter system dump datafile 28 block 17665; alter system dump datafile 28 block 17792; alter system dump datafile 28 block 17793; alter system dump datafile 28 block 17920; alter system dump datafile 28 block 17921; alter system dump datafile 28 block 18048; alter system dump datafile 28 block 18049; alter system dump datafile 28 block 18176; alter system dump datafile 28 block 18177; alter system dump datafile 28 block 18304; alter system dump datafile 28 block 18305; alter system dump datafile 28 block 18432; alter system dump datafile 28 block 18433; alter system dump datafile 28 block 18560; alter system dump datafile 28 block 18561; alter system dump datafile 28 block 18688; alter system dump datafile 28 block 18689; alter system dump datafile 28 block 18816; alter system dump datafile 28 block 18817; alter system dump datafile 28 block 18944; alter system dump datafile 28 block 18945; alter system dump datafile 28 block 19072; alter system dump datafile 28 block 19073; alter system dump datafile 28 block 19200; alter system dump datafile 28 block 19201; alter system dump datafile 28 block 19328; alter system dump datafile 28 block 19329; alter system dump datafile 28 block 19456; alter system dump datafile 28 block 19584; alter system dump datafile 28 block 19585; alter system dump datafile 28 block 19586; alter system dump datafile 28 block 19587; alter system dump datafile 28 block 20608; alter system dump datafile 28 block 20609; alter system dump datafile 28 block 20610; alter system dump datafile 28 block 20611; alter system dump datafile 28 block 21632; alter system dump datafile 28 block 21633; alter system dump datafile 28 block 21634; alter system dump datafile 28 block 21635; alter system dump datafile 28 block 22656; alter system dump datafile 28 block 22657; alter system dump datafile 28 block 22658; alter system dump datafile 28 block 22659; alter system dump datafile 28 block 23680; alter system dump datafile 28 block 23681; alter system dump datafile 28 block 23682; alter system dump datafile 28 block 23683; alter system dump datafile 28 block 24704; alter system dump datafile 28 block 24705; alter system dump datafile 28 block 24706; alter system dump datafile 28 block 24707; alter system dump datafile 28 block 25728; alter system dump datafile 28 block 25729; alter system dump datafile 28 block 25730; alter system dump datafile 28 block 25731; alter system dump datafile 28 block 26752; alter system dump datafile 28 block 26753; alter system dump datafile 28 block 26754; alter system dump datafile 28 block 26755; alter system dump datafile 28 block 27776; alter system dump datafile 28 block 27777; alter system dump datafile 28 block 27778; alter system dump datafile 28 block 27779; alter system dump datafile 28 block 28800; alter system dump datafile 28 block 28801; alter system dump datafile 28 block 28802; alter system dump datafile 28 block 28803; alter system dump datafile 28 block 29824; alter system dump datafile 28 block 29825; alter system dump datafile 28 block 29826; alter system dump datafile 28 block 29827; alter system dump datafile 28 block 30848; alter system dump datafile 28 block 30849; alter system dump datafile 28 block 30850; alter system dump datafile 28 block 30851; alter system dump datafile 28 block 31872; alter system dump datafile 28 block 31873; alter system dump datafile 28 block 31874; alter system dump datafile 28 block 31875; alter system dump datafile 28 block 32896; alter system dump datafile 28 block 32897; alter system dump datafile 28 block 32898; alter system dump datafile 28 block 32899; select value from v$diag_info where name='Default Trace File'; 再生成上面L1的trace alter session set tracefile_identifier='L1_a_drop11'; oradebug setmypid alter system dump datafile 28 block 11392; alter system dump datafile 28 block 11408; alter system dump datafile 28 block 11424; alter system dump datafile 28 block 11440; alter system dump datafile 28 block 11456; alter system dump datafile 28 block 11472; alter system dump datafile 28 block 11488; alter system dump datafile 28 block 11504; alter system dump datafile 28 block 11520; alter system dump datafile 28 block 11521; alter system dump datafile 28 block 11648; alter system dump datafile 28 block 11649; alter system dump datafile 28 block 11776; alter system dump datafile 28 block 11777; alter system dump datafile 28 block 11904; alter system dump datafile 28 block 11905; alter system dump datafile 28 block 12032; alter system dump datafile 28 block 12033; alter system dump datafile 28 block 12160; alter system dump datafile 28 block 12161; alter system dump datafile 28 block 12288; alter system dump datafile 28 block 12289; alter system dump datafile 28 block 12416; alter system dump datafile 28 block 12417; alter system dump datafile 28 block 12544; alter system dump datafile 28 block 12545; alter system dump datafile 28 block 12672; alter system dump datafile 28 block 12673; alter system dump datafile 28 block 12800; alter system dump datafile 28 block 12801; alter system dump datafile 28 block 12928; alter system dump datafile 28 block 12929; alter system dump datafile 28 block 13056; alter system dump datafile 28 block 13057; alter system dump datafile 28 block 13184; alter system dump datafile 28 block 13185; alter system dump datafile 28 block 13312; alter system dump datafile 28 block 13313; alter system dump datafile 28 block 13440; alter system dump datafile 28 block 13441; alter system dump datafile 28 block 13568; alter system dump datafile 28 block 13569; alter system dump datafile 28 block 13696; alter system dump datafile 28 block 13697; alter system dump datafile 28 block 13824; alter system dump datafile 28 block 13825; alter system dump datafile 28 block 13952; alter system dump datafile 28 block 13953; alter system dump datafile 28 block 14080; alter system dump datafile 28 block 14081; alter system dump datafile 28 block 14208; alter system dump datafile 28 block 14209; alter system dump datafile 28 block 14336; alter system dump datafile 28 block 14337; alter system dump datafile 28 block 14464; alter system dump datafile 28 block 14465; alter system dump datafile 28 block 14592; alter system dump datafile 28 block 14593; alter system dump datafile 28 block 14720; alter system dump datafile 28 block 14721; alter system dump datafile 28 block 14848; alter system dump datafile 28 block 14849; alter system dump datafile 28 block 14976; alter system dump datafile 28 block 14977; alter system dump datafile 28 block 15104; alter system dump datafile 28 block 15105; alter system dump datafile 28 block 15232; alter system dump datafile 28 block 15233; alter system dump datafile 28 block 15360; alter system dump datafile 28 block 15361; alter system dump datafile 28 block 15488; alter system dump datafile 28 block 15489; alter system dump datafile 28 block 15616; alter system dump datafile 28 block 15617; alter system dump datafile 28 block 15744; alter system dump datafile 28 block 15745; alter system dump datafile 28 block 15872; alter system dump datafile 28 block 15873; alter system dump datafile 28 block 16000; alter system dump datafile 28 block 16001; alter system dump datafile 28 block 16128; alter system dump datafile 28 block 16129; alter system dump datafile 28 block 16256; alter system dump datafile 28 block 16257; alter system dump datafile 28 block 16384; alter system dump datafile 28 block 16385; alter system dump datafile 28 block 16512; alter system dump datafile 28 block 16513; alter system dump datafile 28 block 16640; alter system dump datafile 28 block 16641; alter system dump datafile 28 block 16768; alter system dump datafile 28 block 16769; alter system dump datafile 28 block 16896; alter system dump datafile 28 block 16897; alter system dump datafile 28 block 17024; alter system dump datafile 28 block 17025; alter system dump datafile 28 block 17152; alter system dump datafile 28 block 17153; alter system dump datafile 28 block 17280; alter system dump datafile 28 block 17281; alter system dump datafile 28 block 17408; alter system dump datafile 28 block 17409; alter system dump datafile 28 block 17536; alter system dump datafile 28 block 17537; alter system dump datafile 28 block 17664; alter system dump datafile 28 block 17665; alter system dump datafile 28 block 17792; alter system dump datafile 28 block 17793; alter system dump datafile 28 block 17920; alter system dump datafile 28 block 17921; alter system dump datafile 28 block 18048; alter system dump datafile 28 block 18049; alter system dump datafile 28 block 18176; alter system dump datafile 28 block 18177; alter system dump datafile 28 block 18304; alter system dump datafile 28 block 18305; alter system dump datafile 28 block 18432; alter system dump datafile 28 block 18433; alter system dump datafile 28 block 18560; alter system dump datafile 28 block 18561; alter system dump datafile 28 block 18688; alter system dump datafile 28 block 18689; alter system dump datafile 28 block 18816; alter system dump datafile 28 block 18817; alter system dump datafile 28 block 18944; alter system dump datafile 28 block 18945; alter system dump datafile 28 block 19072; alter system dump datafile 28 block 19073; alter system dump datafile 28 block 19200; alter system dump datafile 28 block 19201; alter system dump datafile 28 block 19328; alter system dump datafile 28 block 19329; alter system dump datafile 28 block 19456; alter system dump datafile 28 block 19584; alter system dump datafile 28 block 19585; alter system dump datafile 28 block 19586; alter system dump datafile 28 block 19587; alter system dump datafile 28 block 20608; alter system dump datafile 28 block 20609; alter system dump datafile 28 block 20610; alter system dump datafile 28 block 20611; alter system dump datafile 28 block 21632; alter system dump datafile 28 block 21633; alter system dump datafile 28 block 21634; alter system dump datafile 28 block 21635; alter system dump datafile 28 block 22656; alter system dump datafile 28 block 22657; alter system dump datafile 28 block 22658; alter system dump datafile 28 block 22659; alter system dump datafile 28 block 23680; alter system dump datafile 28 block 23681; alter system dump datafile 28 block 23682; alter system dump datafile 28 block 23683; alter system dump datafile 28 block 24704; alter system dump datafile 28 block 24705; alter system dump datafile 28 block 24706; alter system dump datafile 28 block 24707; alter system dump datafile 28 block 25728; alter system dump datafile 28 block 25729; alter system dump datafile 28 block 25730; alter system dump datafile 28 block 25731; alter system dump datafile 28 block 26752; alter system dump datafile 28 block 26753; alter system dump datafile 28 block 26754; alter system dump datafile 28 block 26755; alter system dump datafile 28 block 27776; alter system dump datafile 28 block 27777; alter system dump datafile 28 block 27778; alter system dump datafile 28 block 27779; alter system dump datafile 28 block 28800; alter system dump datafile 28 block 28801; alter system dump datafile 28 block 28802; alter system dump datafile 28 block 28803; alter system dump datafile 28 block 29824; alter system dump datafile 28 block 29825; alter system dump datafile 28 block 29826; alter system dump datafile 28 block 29827; alter system dump datafile 28 block 30848; alter system dump datafile 28 block 30849; alter system dump datafile 28 block 30850; alter system dump datafile 28 block 30851; alter system dump datafile 28 block 31872; alter system dump datafile 28 block 31873; alter system dump datafile 28 block 31874; alter system dump datafile 28 block 31875; alter system dump datafile 28 block 32896; alter system dump datafile 28 block 32897; alter system dump datafile 28 block 32898; alter system dump datafile 28 block 32899;   oradebug close_trace oradebug tracefile_name 文件名 /u02/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5286_L1_a_drop11.trc grep -i 'Length:' /u02/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5286_L1_a_drop11.trc|grep -in 'Offset:'|sed 's/://g'|sed 's/0x//g'|awk '{print "select "$1 " as n_num,\47" $2 "\47 as n_dba," $4 " as n_len from dual union all"}' 生成语句： select 1 as n_num,'07002c80' as n_dba,8 as n_len from dual union all select 2 as n_num,'07002c88' as n_dba,8 as n_len from dual union all select 3 as n_num,'07002c90' as n_dba,8 as n_len from dual union all select 4 as n_num,'07002c98' as n_dba,8 as n_len from dual union all select 5 as n_num,'07002ca0' as n_dba,8 as n_len from dual union all select 6 as n_num,'07002ca8' as n_dba,8 as n_len from dual union all select 7 as n_num,'07002cb0' as n_dba,8 as n_len from dual union all select 8 as n_num,'07002cb8' as n_dba,8 as n_len from dual union all select 9 as n_num,'07002cc0' as n_dba,8 as n_len from dual union all select 10 as n_num,'07002cc8' as n_dba,8 as n_len from dual union all select 11 as n_num,'07002cd0' as n_dba,8 as n_len from dual union all select 12 as n_num,'07002cd8' as n_dba,8 as n_len from dual union all select 13 as n_num,'07002ce0' as n_dba,8 as n_len from dual union all select 14 as n_num,'07002ce8' as n_dba,8 as n_len from dual union all select 15 as n_num,'07002cf0' as n_dba,8 as n_len from dual union all select 16 as n_num,'07002cf8' as n_dba,8 as n_len from dual union all select 17 as n_num,'07002d00' as n_dba,64 as n_len from dual union all select 18 as n_num,'07002d40' as n_dba,64 as n_len from dual union all select 19 as n_num,'07002d80' as n_dba,64 as n_len from dual union all select 20 as n_num,'07002dc0' as n_dba,64 as n_len from dual union all select 21 as n_num,'07002e00' as n_dba,64 as n_len from dual union all select 22 as n_num,'07002e40' as n_dba,64 as n_len from dual union all select 23 as n_num,'07002e80' as n_dba,64 as n_len from dual union all select 24 as n_num,'07002ec0' as n_dba,64 as n_len from dual union all select 25 as n_num,'07002f00' as n_dba,64 as n_len from dual union all select 26 as n_num,'07002f40' as n_dba,64 as n_len from dual union all select 27 as n_num,'07002f80' as n_dba,64 as n_len from dual union all select 28 as n_num,'07002fc0' as n_dba,64 as n_len from dual union all select 29 as n_num,'07003000' as n_dba,64 as n_len from dual union all select 30 as n_num,'07003040' as n_dba,64 as n_len from dual union all select 31 as n_num,'07003080' as n_dba,64 as n_len from dual union all select 32 as n_num,'070030c0' as n_dba,64 as n_len from dual union all select 33 as n_num,'07003100' as n_dba,64 as n_len from dual union all select 34 as n_num,'07003140' as n_dba,64 as n_len from dual union all select 35 as n_num,'07003180' as n_dba,64 as n_len from dual union all select 36 as n_num,'070031c0' as n_dba,64 as n_len from dual union all select 37 as n_num,'07003200' as n_dba,64 as n_len from dual union all select 38 as n_num,'07003240' as n_dba,64 as n_len from dual union all select 39 as n_num,'07003280' as n_dba,64 as n_len from dual union all select 40 as n_num,'070032c0' as n_dba,64 as n_len from dual union all select 41 as n_num,'07003300' as n_dba,64 as n_len from dual union all select 42 as n_num,'07003340' as n_dba,64 as n_len from dual union all select 43 as n_num,'07003380' as n_dba,64 as n_len from dual union all select 44 as n_num,'070033c0' as n_dba,64 as n_len from dual union all select 45 as n_num,'07003400' as n_dba,64 as n_len from dual union all select 46 as n_num,'07003440' as n_dba,64 as n_len from dual union all select 47 as n_num,'07003480' as n_dba,64 as n_len from dual union all select 48 as n_num,'070034c0' as n_dba,64 as n_len from dual union all select 49 as n_num,'07003500' as n_dba,64 as n_len from dual union all select 50 as n_num,'07003540' as n_dba,64 as n_len from dual union all select 51 as n_num,'07003580' as n_dba,64 as n_len from dual union all select 52 as n_num,'070035c0' as n_dba,64 as n_len from dual union all select 53 as n_num,'07003600' as n_dba,64 as n_len from dual union all select 54 as n_num,'07003640' as n_dba,64 as n_len from dual union all select 55 as n_num,'07003680' as n_dba,64 as n_len from dual union all select 56 as n_num,'070036c0' as n_dba,64 as n_len from dual union all select 57 as n_num,'07003700' as n_dba,64 as n_len from dual union all select 58 as n_num,'07003740' as n_dba,64 as n_len from dual union all select 59 as n_num,'07003780' as n_dba,64 as n_len from dual union all select 60 as n_num,'070037c0' as n_dba,64 as n_len from dual union all select 61 as n_num,'07003800' as n_dba,64 as n_len from dual union all select 62 as n_num,'07003840' as n_dba,64 as n_len from dual union all select 63 as n_num,'07003880' as n_dba,64 as n_len from dual union all select 64 as n_num,'070038c0' as n_dba,64 as n_len from dual union all select 65 as n_num,'07003900' as n_dba,64 as n_len from dual union all select 66 as n_num,'07003940' as n_dba,64 as n_len from dual union all select 67 as n_num,'07003980' as n_dba,64 as n_len from dual union all select 68 as n_num,'070039c0' as n_dba,64 as n_len from dual union all select 69 as n_num,'07003a00' as n_dba,64 as n_len from dual union all select 70 as n_num,'07003a40' as n_dba,64 as n_len from dual union all select 71 as n_num,'07003a80' as n_dba,64 as n_len from dual union all select 72 as n_num,'07003ac0' as n_dba,64 as n_len from dual union all select 73 as n_num,'07003b00' as n_dba,64 as n_len from dual union all select 74 as n_num,'07003b40' as n_dba,64 as n_len from dual union all select 75 as n_num,'07003b80' as n_dba,64 as n_len from dual union all select 76 as n_num,'07003bc0' as n_dba,64 as n_len from dual union all select 77 as n_num,'07003c00' as n_dba,64 as n_len from dual union all select 78 as n_num,'07003c40' as n_dba,64 as n_len from dual union all select 79 as n_num,'07003c80' as n_dba,64 as n_len from dual union all select 80 as n_num,'07003cc0' as n_dba,64 as n_len from dual union all select 81 as n_num,'07003d00' as n_dba,64 as n_len from dual union all select 82 as n_num,'07003d40' as n_dba,64 as n_len from dual union all select 83 as n_num,'07003d80' as n_dba,64 as n_len from dual union all select 84 as n_num,'07003dc0' as n_dba,64 as n_len from dual union all select 85 as n_num,'07003e00' as n_dba,64 as n_len from dual union all select 86 as n_num,'07003e40' as n_dba,64 as n_len from dual union all select 87 as n_num,'07003e80' as n_dba,64 as n_len from dual union all select 88 as n_num,'07003ec0' as n_dba,64 as n_len from dual union all select 89 as n_num,'07003f00' as n_dba,64 as n_len from dual union all select 90 as n_num,'07003f40' as n_dba,64 as n_len from dual union all select 91 as n_num,'07003f80' as n_dba,64 as n_len from dual union all select 92 as n_num,'07003fc0' as n_dba,64 as n_len from dual union all select 93 as n_num,'07004000' as n_dba,64 as n_len from dual union all select 94 as n_num,'07004040' as n_dba,64 as n_len from dual union all select 95 as n_num,'07004080' as n_dba,64 as n_len from dual union all select 96 as n_num,'070040c0' as n_dba,64 as n_len from dual union all select 97 as n_num,'07004100' as n_dba,64 as n_len from dual union all select 98 as n_num,'07004140' as n_dba,64 as n_len from dual union all select 99 as n_num,'07004180' as n_dba,64 as n_len from dual union all select 100 as n_num,'070041c0' as n_dba,64 as n_len from dual union all select 101 as n_num,'07004200' as n_dba,64 as n_len from dual union all select 102 as n_num,'07004240' as n_dba,64 as n_len from dual union all select 103 as n_num,'07004280' as n_dba,64 as n_len from dual union all select 104 as n_num,'070042c0' as n_dba,64 as n_len from dual union all select 105 as n_num,'07004300' as n_dba,64 as n_len from dual union all select 106 as n_num,'07004340' as n_dba,64 as n_len from dual union all select 107 as n_num,'07004380' as n_dba,64 as n_len from dual union all select 108 as n_num,'070043c0' as n_dba,64 as n_len from dual union all select 109 as n_num,'07004400' as n_dba,64 as n_len from dual union all select 110 as n_num,'07004440' as n_dba,64 as n_len from dual union all select 111 as n_num,'07004480' as n_dba,64 as n_len from dual union all select 112 as n_num,'070044c0' as n_dba,64 as n_len from dual union all select 113 as n_num,'07004500' as n_dba,64 as n_len from dual union all select 114 as n_num,'07004540' as n_dba,64 as n_len from dual union all select 115 as n_num,'07004580' as n_dba,64 as n_len from dual union all select 116 as n_num,'070045c0' as n_dba,64 as n_len from dual union all select 117 as n_num,'07004600' as n_dba,64 as n_len from dual union all select 118 as n_num,'07004640' as n_dba,64 as n_len from dual union all select 119 as n_num,'07004680' as n_dba,64 as n_len from dual union all select 120 as n_num,'070046c0' as n_dba,64 as n_len from dual union all select 121 as n_num,'07004700' as n_dba,64 as n_len from dual union all select 122 as n_num,'07004740' as n_dba,64 as n_len from dual union all select 123 as n_num,'07004780' as n_dba,64 as n_len from dual union all select 124 as n_num,'070047c0' as n_dba,64 as n_len from dual union all select 125 as n_num,'07004800' as n_dba,64 as n_len from dual union all select 126 as n_num,'07004840' as n_dba,64 as n_len from dual union all select 127 as n_num,'07004880' as n_dba,64 as n_len from dual union all select 128 as n_num,'070048c0' as n_dba,64 as n_len from dual union all select 129 as n_num,'07004900' as n_dba,64 as n_len from dual union all select 130 as n_num,'07004940' as n_dba,64 as n_len from dual union all select 131 as n_num,'07004980' as n_dba,64 as n_len from dual union all select 132 as n_num,'070049c0' as n_dba,64 as n_len from dual union all select 133 as n_num,'07004a00' as n_dba,64 as n_len from dual union all select 134 as n_num,'07004a40' as n_dba,64 as n_len from dual union all select 135 as n_num,'07004a80' as n_dba,64 as n_len from dual union all select 136 as n_num,'07004ac0' as n_dba,64 as n_len from dual union all select 137 as n_num,'07004b00' as n_dba,64 as n_len from dual union all select 138 as n_num,'07004b40' as n_dba,64 as n_len from dual union all select 139 as n_num,'07004b80' as n_dba,64 as n_len from dual union all select 140 as n_num,'07004bc0' as n_dba,64 as n_len from dual union all select 141 as n_num,'07004c00' as n_dba,128 as n_len from dual union all select 142 as n_num,'07004c80' as n_dba,256 as n_len from dual union all select 143 as n_num,'07004d80' as n_dba,256 as n_len from dual union all select 144 as n_num,'07004e80' as n_dba,256 as n_len from dual union all select 145 as n_num,'07004f80' as n_dba,256 as n_len from dual union all select 146 as n_num,'07005080' as n_dba,256 as n_len from dual union all select 147 as n_num,'07005180' as n_dba,256 as n_len from dual union all select 148 as n_num,'07005280' as n_dba,256 as n_len from dual union all select 149 as n_num,'07005380' as n_dba,256 as n_len from dual union all select 150 as n_num,'07005480' as n_dba,256 as n_len from dual union all select 151 as n_num,'07005580' as n_dba,256 as n_len from dual union all select 152 as n_num,'07005680' as n_dba,256 as n_len from dual union all select 153 as n_num,'07005780' as n_dba,256 as n_len from dual union all select 154 as n_num,'07005880' as n_dba,256 as n_len from dual union all select 155 as n_num,'07005980' as n_dba,256 as n_len from dual union all select 156 as n_num,'07005a80' as n_dba,256 as n_len from dual union all select 157 as n_num,'07005b80' as n_dba,256 as n_len from dual union all select 158 as n_num,'07005c80' as n_dba,256 as n_len from dual union all select 159 as n_num,'07005d80' as n_dba,256 as n_len from dual union all select 160 as n_num,'07005e80' as n_dba,256 as n_len from dual union all select 161 as n_num,'07005f80' as n_dba,256 as n_len from dual union all select 162 as n_num,'07006080' as n_dba,256 as n_len from dual union all select 163 as n_num,'07006180' as n_dba,256 as n_len from dual union all select 164 as n_num,'07006280' as n_dba,256 as n_len from dual union all select 165 as n_num,'07006380' as n_dba,256 as n_len from dual union all select 166 as n_num,'07006480' as n_dba,256 as n_len from dual union all select 167 as n_num,'07006580' as n_dba,256 as n_len from dual union all select 168 as n_num,'07006680' as n_dba,256 as n_len from dual union all select 169 as n_num,'07006780' as n_dba,256 as n_len from dual union all select 170 as n_num,'07006880' as n_dba,256 as n_len from dual union all select 171 as n_num,'07006980' as n_dba,256 as n_len from dual union all select 172 as n_num,'07006a80' as n_dba,256 as n_len from dual union all select 173 as n_num,'07006b80' as n_dba,256 as n_len from dual union all select 174 as n_num,'07006c80' as n_dba,256 as n_len from dual union all select 175 as n_num,'07006d80' as n_dba,256 as n_len from dual union all select 176 as n_num,'07006e80' as n_dba,256 as n_len from dual union all select 177 as n_num,'07006f80' as n_dba,256 as n_len from dual union all select 178 as n_num,'07007080' as n_dba,256 as n_len from dual union all select 179 as n_num,'07007180' as n_dba,256 as n_len from dual union all select 180 as n_num,'07007280' as n_dba,256 as n_len from dual union all select 181 as n_num,'07007380' as n_dba,256 as n_len from dual union all select 182 as n_num,'07007480' as n_dba,256 as n_len from dual union all select 183 as n_num,'07007580' as n_dba,256 as n_len from dual union all select 184 as n_num,'07007680' as n_dba,256 as n_len from dual union all select 185 as n_num,'07007780' as n_dba,256 as n_len from dual union all select 186 as n_num,'07007880' as n_dba,256 as n_len from dual union all select 187 as n_num,'07007980' as n_dba,256 as n_len from dual union all select 188 as n_num,'07007a80' as n_dba,256 as n_len from dual union all select 189 as n_num,'07007b80' as n_dba,256 as n_len from dual union all select 190 as n_num,'07007c80' as n_dba,256 as n_len from dual union all select 191 as n_num,'07007d80' as n_dba,256 as n_len from dual union all select 192 as n_num,'07007e80' as n_dba,256 as n_len from dual union all select 193 as n_num,'07007f80' as n_dba,256 as n_len from dual union all select 194 as n_num,'07008080' as n_dba,256 as n_len from dual union all select 195 as n_num,'07008180' as n_dba,256 as n_len from dual union all select 196 as n_num,'07008280' as n_dba,256 as n_len from dual union all select 197 as n_num,'07008380' as n_dba,256 as n_len from dual  extend map  set linesize 200 pagesize 9999 col dba_em_1 for a20 col dba_em_2 for a20 col n_len for a30 with new_ext as ( select 1 as n_num,'07002c80' as n_dba,8 as n_len from dual union all select 2 as n_num,'07002c88' as n_dba,8 as n_len from dual union all select 3 as n_num,'07002c90' as n_dba,8 as n_len from dual union all select 4 as n_num,'07002c98' as n_dba,8 as n_len from dual union all select 5 as n_num,'07002ca0' as n_dba,8 as n_len from dual union all select 6 as n_num,'07002ca8' as n_dba,8 as n_len from dual union all select 7 as n_num,'07002cb0' as n_dba,8 as n_len from dual union all select 8 as n_num,'07002cb8' as n_dba,8 as n_len from dual union all select 9 as n_num,'07002cc0' as n_dba,8 as n_len from dual union all select 10 as n_num,'07002cc8' as n_dba,8 as n_len from dual union all select 11 as n_num,'07002cd0' as n_dba,8 as n_len from dual union all select 12 as n_num,'07002cd8' as n_dba,8 as n_len from dual union all select 13 as n_num,'07002ce0' as n_dba,8 as n_len from dual union all select 14 as n_num,'07002ce8' as n_dba,8 as n_len from dual union all select 15 as n_num,'07002cf0' as n_dba,8 as n_len from dual union all select 16 as n_num,'07002cf8' as n_dba,8 as n_len from dual union all select 17 as n_num,'07002d00' as n_dba,64 as n_len from dual union all select 18 as n_num,'07002d40' as n_dba,64 as n_len from dual union all select 19 as n_num,'07002d80' as n_dba,64 as n_len from dual union all select 20 as n_num,'07002dc0' as n_dba,64 as n_len from dual union all select 21 as n_num,'07002e00' as n_dba,64 as n_len from dual union all select 22 as n_num,'07002e40' as n_dba,64 as n_len from dual union all select 23 as n_num,'07002e80' as n_dba,64 as n_len from dual union all select 24 as n_num,'07002ec0' as n_dba,64 as n_len from dual union all select 25 as n_num,'07002f00' as n_dba,64 as n_len from dual union all select 26 as n_num,'07002f40' as n_dba,64 as n_len from dual union all select 27 as n_num,'07002f80' as n_dba,64 as n_len from dual union all select 28 as n_num,'07002fc0' as n_dba,64 as n_len from dual union all select 29 as n_num,'07003000' as n_dba,64 as n_len from dual union all select 30 as n_num,'07003040' as n_dba,64 as n_len from dual union all select 31 as n_num,'07003080' as n_dba,64 as n_len from dual union all select 32 as n_num,'070030c0' as n_dba,64 as n_len from dual union all select 33 as n_num,'07003100' as n_dba,64 as n_len from dual union all select 34 as n_num,'07003140' as n_dba,64 as n_len from dual union all select 35 as n_num,'07003180' as n_dba,64 as n_len from dual union all select 36 as n_num,'070031c0' as n_dba,64 as n_len from dual union all select 37 as n_num,'07003200' as n_dba,64 as n_len from dual union all select 38 as n_num,'07003240' as n_dba,64 as n_len from dual union all select 39 as n_num,'07003280' as n_dba,64 as n_len from dual union all select 40 as n_num,'070032c0' as n_dba,64 as n_len from dual union all select 41 as n_num,'07003300' as n_dba,64 as n_len from dual union all select 42 as n_num,'07003340' as n_dba,64 as n_len from dual union all select 43 as n_num,'07003380' as n_dba,64 as n_len from dual union all select 44 as n_num,'070033c0' as n_dba,64 as n_len from dual union all select 45 as n_num,'07003400' as n_dba,64 as n_len from dual union all select 46 as n_num,'07003440' as n_dba,64 as n_len from dual union all select 47 as n_num,'07003480' as n_dba,64 as n_len from dual union all select 48 as n_num,'070034c0' as n_dba,64 as n_len from dual union all select 49 as n_num,'07003500' as n_dba,64 as n_len from dual union all select 50 as n_num,'07003540' as n_dba,64 as n_len from dual union all select 51 as n_num,'07003580' as n_dba,64 as n_len from dual union all select 52 as n_num,'070035c0' as n_dba,64 as n_len from dual union all select 53 as n_num,'07003600' as n_dba,64 as n_len from dual union all select 54 as n_num,'07003640' as n_dba,64 as n_len from dual union all select 55 as n_num,'07003680' as n_dba,64 as n_len from dual union all select 56 as n_num,'070036c0' as n_dba,64 as n_len from dual union all select 57 as n_num,'07003700' as n_dba,64 as n_len from dual union all select 58 as n_num,'07003740' as n_dba,64 as n_len from dual union all select 59 as n_num,'07003780' as n_dba,64 as n_len from dual union all select 60 as n_num,'070037c0' as n_dba,64 as n_len from dual union all select 61 as n_num,'07003800' as n_dba,64 as n_len from dual union all select 62 as n_num,'07003840' as n_dba,64 as n_len from dual union all select 63 as n_num,'07003880' as n_dba,64 as n_len from dual union all select 64 as n_num,'070038c0' as n_dba,64 as n_len from dual union all select 65 as n_num,'07003900' as n_dba,64 as n_len from dual union all select 66 as n_num,'07003940' as n_dba,64 as n_len from dual union all select 67 as n_num,'07003980' as n_dba,64 as n_len from dual union all select 68 as n_num,'070039c0' as n_dba,64 as n_len from dual union all select 69 as n_num,'07003a00' as n_dba,64 as n_len from dual union all select 70 as n_num,'07003a40' as n_dba,64 as n_len from dual union all select 71 as n_num,'07003a80' as n_dba,64 as n_len from dual union all select 72 as n_num,'07003ac0' as n_dba,64 as n_len from dual union all select 73 as n_num,'07003b00' as n_dba,64 as n_len from dual union all select 74 as n_num,'07003b40' as n_dba,64 as n_len from dual union all select 75 as n_num,'07003b80' as n_dba,64 as n_len from dual union all select 76 as n_num,'07003bc0' as n_dba,64 as n_len from dual union all select 77 as n_num,'07003c00' as n_dba,64 as n_len from dual union all select 78 as n_num,'07003c40' as n_dba,64 as n_len from dual union all select 79 as n_num,'07003c80' as n_dba,64 as n_len from dual union all select 80 as n_num,'07003cc0' as n_dba,64 as n_len from dual union all select 81 as n_num,'07003d00' as n_dba,64 as n_len from dual union all select 82 as n_num,'07003d40' as n_dba,64 as n_len from dual union all select 83 as n_num,'07003d80' as n_dba,64 as n_len from dual union all select 84 as n_num,'07003dc0' as n_dba,64 as n_len from dual union all select 85 as n_num,'07003e00' as n_dba,64 as n_len from dual union all select 86 as n_num,'07003e40' as n_dba,64 as n_len from dual union all select 87 as n_num,'07003e80' as n_dba,64 as n_len from dual union all select 88 as n_num,'07003ec0' as n_dba,64 as n_len from dual union all select 89 as n_num,'07003f00' as n_dba,64 as n_len from dual union all select 90 as n_num,'07003f40' as n_dba,64 as n_len from dual union all select 91 as n_num,'07003f80' as n_dba,64 as n_len from dual union all select 92 as n_num,'07003fc0' as n_dba,64 as n_len from dual union all select 93 as n_num,'07004000' as n_dba,64 as n_len from dual union all select 94 as n_num,'07004040' as n_dba,64 as n_len from dual union all select 95 as n_num,'07004080' as n_dba,64 as n_len from dual union all select 96 as n_num,'070040c0' as n_dba,64 as n_len from dual union all select 97 as n_num,'07004100' as n_dba,64 as n_len from dual union all select 98 as n_num,'07004140' as n_dba,64 as n_len from dual union all select 99 as n_num,'07004180' as n_dba,64 as n_len from dual union all select 100 as n_num,'070041c0' as n_dba,64 as n_len from dual union all select 101 as n_num,'07004200' as n_dba,64 as n_len from dual union all select 102 as n_num,'07004240' as n_dba,64 as n_len from dual union all select 103 as n_num,'07004280' as n_dba,64 as n_len from dual union all select 104 as n_num,'070042c0' as n_dba,64 as n_len from dual union all select 105 as n_num,'07004300' as n_dba,64 as n_len from dual union all select 106 as n_num,'07004340' as n_dba,64 as n_len from dual union all select 107 as n_num,'07004380' as n_dba,64 as n_len from dual union all select 108 as n_num,'070043c0' as n_dba,64 as n_len from dual union all select 109 as n_num,'07004400' as n_dba,64 as n_len from dual union all select 110 as n_num,'07004440' as n_dba,64 as n_len from dual union all select 111 as n_num,'07004480' as n_dba,64 as n_len from dual union all select 112 as n_num,'070044c0' as n_dba,64 as n_len from dual union all select 113 as n_num,'07004500' as n_dba,64 as n_len from dual union all select 114 as n_num,'07004540' as n_dba,64 as n_len from dual union all select 115 as n_num,'07004580' as n_dba,64 as n_len from dual union all select 116 as n_num,'070045c0' as n_dba,64 as n_len from dual union all select 117 as n_num,'07004600' as n_dba,64 as n_len from dual union all select 118 as n_num,'07004640' as n_dba,64 as n_len from dual union all select 119 as n_num,'07004680' as n_dba,64 as n_len from dual union all select 120 as n_num,'070046c0' as n_dba,64 as n_len from dual union all select 121 as n_num,'07004700' as n_dba,64 as n_len from dual union all select 122 as n_num,'07004740' as n_dba,64 as n_len from dual union all select 123 as n_num,'07004780' as n_dba,64 as n_len from dual union all select 124 as n_num,'070047c0' as n_dba,64 as n_len from dual union all select 125 as n_num,'07004800' as n_dba,64 as n_len from dual union all select 126 as n_num,'07004840' as n_dba,64 as n_len from dual union all select 127 as n_num,'07004880' as n_dba,64 as n_len from dual union all select 128 as n_num,'070048c0' as n_dba,64 as n_len from dual union all select 129 as n_num,'07004900' as n_dba,64 as n_len from dual union all select 130 as n_num,'07004940' as n_dba,64 as n_len from dual union all select 131 as n_num,'07004980' as n_dba,64 as n_len from dual union all select 132 as n_num,'070049c0' as n_dba,64 as n_len from dual union all select 133 as n_num,'07004a00' as n_dba,64 as n_len from dual union all select 134 as n_num,'07004a40' as n_dba,64 as n_len from dual union all select 135 as n_num,'07004a80' as n_dba,64 as n_len from dual union all select 136 as n_num,'07004ac0' as n_dba,64 as n_len from dual union all select 137 as n_num,'07004b00' as n_dba,64 as n_len from dual union all select 138 as n_num,'07004b40' as n_dba,64 as n_len from dual union all select 139 as n_num,'07004b80' as n_dba,64 as n_len from dual union all select 140 as n_num,'07004bc0' as n_dba,64 as n_len from dual union all select 141 as n_num,'07004c00' as n_dba,128 as n_len from dual union all select 142 as n_num,'07004c80' as n_dba,256 as n_len from dual union all select 143 as n_num,'07004d80' as n_dba,256 as n_len from dual union all select 144 as n_num,'07004e80' as n_dba,256 as n_len from dual union all select 145 as n_num,'07004f80' as n_dba,256 as n_len from dual union all select 146 as n_num,'07005080' as n_dba,256 as n_len from dual union all select 147 as n_num,'07005180' as n_dba,256 as n_len from dual union all select 148 as n_num,'07005280' as n_dba,256 as n_len from dual union all select 149 as n_num,'07005380' as n_dba,256 as n_len from dual union all select 150 as n_num,'07005480' as n_dba,256 as n_len from dual union all select 151 as n_num,'07005580' as n_dba,256 as n_len from dual union all select 152 as n_num,'07005680' as n_dba,256 as n_len from dual union all select 153 as n_num,'07005780' as n_dba,256 as n_len from dual union all select 154 as n_num,'07005880' as n_dba,256 as n_len from dual union all select 155 as n_num,'07005980' as n_dba,256 as n_len from dual union all select 156 as n_num,'07005a80' as n_dba,256 as n_len from dual union all select 157 as n_num,'07005b80' as n_dba,256 as n_len from dual union all select 158 as n_num,'07005c80' as n_dba,256 as n_len from dual union all select 159 as n_num,'07005d80' as n_dba,256 as n_len from dual union all select 160 as n_num,'07005e80' as n_dba,256 as n_len from dual union all select 161 as n_num,'07005f80' as n_dba,256 as n_len from dual union all select 162 as n_num,'07006080' as n_dba,256 as n_len from dual union all select 163 as n_num,'07006180' as n_dba,256 as n_len from dual union all select 164 as n_num,'07006280' as n_dba,256 as n_len from dual union all select 165 as n_num,'07006380' as n_dba,256 as n_len from dual union all select 166 as n_num,'07006480' as n_dba,256 as n_len from dual union all select 167 as n_num,'07006580' as n_dba,256 as n_len from dual union all select 168 as n_num,'07006680' as n_dba,256 as n_len from dual union all select 169 as n_num,'07006780' as n_dba,256 as n_len from dual union all select 170 as n_num,'07006880' as n_dba,256 as n_len from dual union all select 171 as n_num,'07006980' as n_dba,256 as n_len from dual union all select 172 as n_num,'07006a80' as n_dba,256 as n_len from dual union all select 173 as n_num,'07006b80' as n_dba,256 as n_len from dual union all select 174 as n_num,'07006c80' as n_dba,256 as n_len from dual union all select 175 as n_num,'07006d80' as n_dba,256 as n_len from dual union all select 176 as n_num,'07006e80' as n_dba,256 as n_len from dual union all select 177 as n_num,'07006f80' as n_dba,256 as n_len from dual union all select 178 as n_num,'07007080' as n_dba,256 as n_len from dual union all select 179 as n_num,'07007180' as n_dba,256 as n_len from dual union all select 180 as n_num,'07007280' as n_dba,256 as n_len from dual union all select 181 as n_num,'07007380' as n_dba,256 as n_len from dual union all select 182 as n_num,'07007480' as n_dba,256 as n_len from dual union all select 183 as n_num,'07007580' as n_dba,256 as n_len from dual union all select 184 as n_num,'07007680' as n_dba,256 as n_len from dual union all select 185 as n_num,'07007780' as n_dba,256 as n_len from dual union all select 186 as n_num,'07007880' as n_dba,256 as n_len from dual union all select 187 as n_num,'07007980' as n_dba,256 as n_len from dual union all select 188 as n_num,'07007a80' as n_dba,256 as n_len from dual union all select 189 as n_num,'07007b80' as n_dba,256 as n_len from dual union all select 190 as n_num,'07007c80' as n_dba,256 as n_len from dual union all select 191 as n_num,'07007d80' as n_dba,256 as n_len from dual union all select 192 as n_num,'07007e80' as n_dba,256 as n_len from dual union all select 193 as n_num,'07007f80' as n_dba,256 as n_len from dual union all select 194 as n_num,'07008080' as n_dba,256 as n_len from dual union all select 195 as n_num,'07008180' as n_dba,256 as n_len from dual union all select 196 as n_num,'07008280' as n_dba,256 as n_len from dual union all select 197 as n_num,'07008380' as n_dba,256 as n_len from dual  ), new_ext_temp as( select   n_num,  dbms_utility.data_block_address_file(TO_NUMBER(n_dba, 'XXXXXXXX')) file_id,  dbms_utility.data_block_address_block(TO_NUMBER(n_dba,'XXXXXXXX')) block_id,  'm /x '||substr(n_dba,7,2)||substr(n_dba,5,2) ||' offset '||to_char(280+(n_num-1)*8) dba_em_1,    'm /x '||substr(n_dba,3,2)||substr(n_dba,1,2) ||' offset '||to_char(280+(n_num-1)*8+2) dba_em_2,  case when n_num<=16                        then  'm /x '||'0800'||' offset '||to_char(280+(n_num-1)*8+4)       when n_num>16 and n_num<=16+63        then  'm /x '||'8000'||' offset '||to_char(280+(n_num-1)*8+4)       when n_num>16+63 and n_num<=16+63+120 then  'm /x '||'0004'||' offset '||to_char(280+(n_num-1)*8+4)       when n_num>16+63+120                  then  'm /x '||'0020'||' offset '||to_char(280+(n_num-1)*8+4)       else '0'  end as n_len  from (select rownum n_num,n_dba from new_ext where n_num<=16 or mod(n_num,2)=1)  ) select dba_em_1 from new_ext_temp where n_num>1 union all select dba_em_2 from new_ext_temp where n_num>1 union all select n_len from new_ext_temp where n_num>1 ; m /x 8059 offset 960 m /x 805b offset 968 m /x 805d offset 976 m /x 805f offset 984 m /x 8061 offset 992 m /x 8063 offset 1000 m /x 8065 offset 1008 m /x 8067 offset 1016 m /x 8069 offset 1024 m /x 806b offset 1032 m /x 806d offset 1040 m /x 806f offset 1048 m /x 8071 offset 1056 m /x 8073 offset 1064 m /x 8075 offset 1072 m /x 8077 offset 1080 m /x 8079 offset 1088 m /x 807b offset 1096 m /x 807d offset 1104 m /x 807f offset 1112 m /x 8081 offset 1120 m /x 8083 offset 1128 m /x 882c offset 288 m /x 902c offset 296 m /x 982c offset 304 m /x a02c offset 312 m /x a82c offset 320 m /x b02c offset 328 m /x b82c offset 336 m /x c02c offset 344 m /x c82c offset 352 m /x d02c offset 360 m /x d82c offset 368 m /x e02c offset 376 m /x e82c offset 384 m /x f02c offset 392 m /x f82c offset 400 m /x 002d offset 408 m /x 802d offset 416 m /x 002e offset 424 m /x 802e offset 432 m /x 002f offset 440 m /x 802f offset 448 m /x 0030 offset 456 m /x 8030 offset 464 m /x 0031 offset 472 m /x 8031 offset 480 m /x 0032 offset 488 m /x 8032 offset 496 m /x 0033 offset 504 m /x 8033 offset 512 m /x 0034 offset 520 m /x 8034 offset 528 m /x 0035 offset 536 m /x 8035 offset 544 m /x 0036 offset 552 m /x 8036 offset 560 m /x 0037 offset 568 m /x 8037 offset 576 m /x 0038 offset 584 m /x 8038 offset 592 m /x 0039 offset 600 m /x 8039 offset 608 m /x 003a offset 616 m /x 803a offset 624 m /x 003b offset 632 m /x 803b offset 640 m /x 003c offset 648 m /x 803c offset 656 m /x 003d offset 664 m /x 803d offset 672 m /x 003e offset 680 m /x 803e offset 688 m /x 003f offset 696 m /x 803f offset 704 m /x 0040 offset 712 m /x 8040 offset 720 m /x 0041 offset 728 m /x 8041 offset 736 m /x 0042 offset 744 m /x 8042 offset 752 m /x 0043 offset 760 m /x 8043 offset 768 m /x 0044 offset 776 m /x 8044 offset 784 m /x 0045 offset 792 m /x 8045 offset 800 m /x 0046 offset 808 m /x 8046 offset 816 m /x 0047 offset 824 m /x 8047 offset 832 m /x 0048 offset 840 m /x 8048 offset 848 m /x 0049 offset 856 m /x 8049 offset 864 m /x 004a offset 872 m /x 804a offset 880 m /x 004b offset 888 m /x 804b offset 896 m /x 004c offset 904 m /x 804d offset 912 m /x 804f offset 920 m /x 8051 offset 928 m /x 8053 offset 936 m /x 8055 offset 944 m /x 8057 offset 952 m /x 0007 offset 962 m /x 0007 offset 970 m /x 0007 offset 978 m /x 0007 offset 986 m /x 0007 offset 994 m /x 0007 offset 1002 m /x 0007 offset 1010 m /x 0007 offset 1018 m /x 0007 offset 1026 m /x 0007 offset 1034 m /x 0007 offset 1042 m /x 0007 offset 1050 m /x 0007 offset 1058 m /x 0007 offset 1066 m /x 0007 offset 1074 m /x 0007 offset 1082 m /x 0007 offset 1090 m /x 0007 offset 1098 m /x 0007 offset 1106 m /x 0007 offset 1114 m /x 0007 offset 1122 m /x 0007 offset 1130 m /x 0007 offset 290 m /x 0007 offset 298 m /x 0007 offset 306 m /x 0007 offset 314 m /x 0007 offset 322 m /x 0007 offset 330 m /x 0007 offset 338 m /x 0007 offset 346 m /x 0007 offset 354 m /x 0007 offset 362 m /x 0007 offset 370 m /x 0007 offset 378 m /x 0007 offset 386 m /x 0007 offset 394 m /x 0007 offset 402 m /x 0007 offset 410 m /x 0007 offset 418 m /x 0007 offset 426 m /x 0007 offset 434 m /x 0007 offset 442 m /x 0007 offset 450 m /x 0007 offset 458 m /x 0007 offset 466 m /x 0007 offset 474 m /x 0007 offset 482 m /x 0007 offset 490 m /x 0007 offset 498 m /x 0007 offset 506 m /x 0007 offset 514 m /x 0007 offset 522 m /x 0007 offset 530 m /x 0007 offset 538 m /x 0007 offset 546 m /x 0007 offset 554 m /x 0007 offset 562 m /x 0007 offset 570 m /x 0007 offset 578 m /x 0007 offset 586 m /x 0007 offset 594 m /x 0007 offset 602 m /x 0007 offset 610 m /x 0007 offset 618 m /x 0007 offset 626 m /x 0007 offset 634 m /x 0007 offset 642 m /x 0007 offset 650 m /x 0007 offset 658 m /x 0007 offset 666 m /x 0007 offset 674 m /x 0007 offset 682 m /x 0007 offset 690 m /x 0007 offset 698 m /x 0007 offset 706 m /x 0007 offset 714 m /x 0007 offset 722 m /x 0007 offset 730 m /x 0007 offset 738 m /x 0007 offset 746 m /x 0007 offset 754 m /x 0007 offset 762 m /x 0007 offset 770 m /x 0007 offset 778 m /x 0007 offset 786 m /x 0007 offset 794 m /x 0007 offset 802 m /x 0007 offset 810 m /x 0007 offset 818 m /x 0007 offset 826 m /x 0007 offset 834 m /x 0007 offset 842 m /x 0007 offset 850 m /x 0007 offset 858 m /x 0007 offset 866 m /x 0007 offset 874 m /x 0007 offset 882 m /x 0007 offset 890 m /x 0007 offset 898 m /x 0007 offset 906 m /x 0007 offset 914 m /x 0007 offset 922 m /x 0007 offset 930 m /x 0007 offset 938 m /x 0007 offset 946 m /x 0007 offset 954 m /x 0004 offset 964 m /x 0004 offset 972 m /x 0004 offset 980 m /x 0004 offset 988 m /x 0004 offset 996 m /x 0004 offset 1004 m /x 0004 offset 1012 m /x 0004 offset 1020 m /x 0004 offset 1028 m /x 0004 offset 1036 m /x 0004 offset 1044 m /x 0004 offset 1052 m /x 0004 offset 1060 m /x 0004 offset 1068 m /x 0004 offset 1076 m /x 0004 offset 1084 m /x 0004 offset 1092 m /x 0004 offset 1100 m /x 0004 offset 1108 m /x 0004 offset 1116 m /x 0004 offset 1124 m /x 0004 offset 1132 m /x 0800 offset 292 m /x 0800 offset 300 m /x 0800 offset 308 m /x 0800 offset 316 m /x 0800 offset 324 m /x 0800 offset 332 m /x 0800 offset 340 m /x 0800 offset 348 m /x 0800 offset 356 m /x 0800 offset 364 m /x 0800 offset 372 m /x 0800 offset 380 m /x 0800 offset 388 m /x 0800 offset 396 m /x 0800 offset 404 m /x 8000 offset 412 m /x 8000 offset 420 m /x 8000 offset 428 m /x 8000 offset 436 m /x 8000 offset 444 m /x 8000 offset 452 m /x 8000 offset 460 m /x 8000 offset 468 m /x 8000 offset 476 m /x 8000 offset 484 m /x 8000 offset 492 m /x 8000 offset 500 m /x 8000 offset 508 m /x 8000 offset 516 m /x 8000 offset 524 m /x 8000 offset 532 m /x 8000 offset 540 m /x 8000 offset 548 m /x 8000 offset 556 m /x 8000 offset 564 m /x 8000 offset 572 m /x 8000 offset 580 m /x 8000 offset 588 m /x 8000 offset 596 m /x 8000 offset 604 m /x 8000 offset 612 m /x 8000 offset 620 m /x 8000 offset 628 m /x 8000 offset 636 m /x 8000 offset 644 m /x 8000 offset 652 m /x 8000 offset 660 m /x 8000 offset 668 m /x 8000 offset 676 m /x 8000 offset 684 m /x 8000 offset 692 m /x 8000 offset 700 m /x 8000 offset 708 m /x 8000 offset 716 m /x 8000 offset 724 m /x 8000 offset 732 m /x 8000 offset 740 m /x 8000 offset 748 m /x 8000 offset 756 m /x 8000 offset 764 m /x 8000 offset 772 m /x 8000 offset 780 m /x 8000 offset 788 m /x 8000 offset 796 m /x 8000 offset 804 m /x 8000 offset 812 m /x 8000 offset 820 m /x 8000 offset 828 m /x 8000 offset 836 m /x 8000 offset 844 m /x 8000 offset 852 m /x 8000 offset 860 m /x 8000 offset 868 m /x 8000 offset 876 m /x 8000 offset 884 m /x 8000 offset 892 m /x 8000 offset 900 m /x 8000 offset 908 m /x 0004 offset 916 m /x 0004 offset 924 m /x 0004 offset 932 m /x 0004 offset 940 m /x 0004 offset 948 m /x 0004 offset 956 aux  extmap set linesize 200 pagesize 9999 col dba_em_1 for a20 col dba_em_2 for a20 col n_len for a30 with all_ext as ( select 1 as n_num,'07002c80' as n_dba,8 as n_len from dual union all select 2 as n_num,'07002c88' as n_dba,8 as n_len from dual union all select 3 as n_num,'07002c90' as n_dba,8 as n_len from dual union all select 4 as n_num,'07002c98' as n_dba,8 as n_len from dual union all select 5 as n_num,'07002ca0' as n_dba,8 as n_len from dual union all select 6 as n_num,'07002ca8' as n_dba,8 as n_len from dual union all select 7 as n_num,'07002cb0' as n_dba,8 as n_len from dual union all select 8 as n_num,'07002cb8' as n_dba,8 as n_len from dual union all select 9 as n_num,'07002cc0' as n_dba,8 as n_len from dual union all select 10 as n_num,'07002cc8' as n_dba,8 as n_len from dual union all select 11 as n_num,'07002cd0' as n_dba,8 as n_len from dual union all select 12 as n_num,'07002cd8' as n_dba,8 as n_len from dual union all select 13 as n_num,'07002ce0' as n_dba,8 as n_len from dual union all select 14 as n_num,'07002ce8' as n_dba,8 as n_len from dual union all select 15 as n_num,'07002cf0' as n_dba,8 as n_len from dual union all select 16 as n_num,'07002cf8' as n_dba,8 as n_len from dual union all select 17 as n_num,'07002d00' as n_dba,64 as n_len from dual union all select 18 as n_num,'07002d40' as n_dba,64 as n_len from dual union all select 19 as n_num,'07002d80' as n_dba,64 as n_len from dual union all select 20 as n_num,'07002dc0' as n_dba,64 as n_len from dual union all select 21 as n_num,'07002e00' as n_dba,64 as n_len from dual union all select 22 as n_num,'07002e40' as n_dba,64 as n_len from dual union all select 23 as n_num,'07002e80' as n_dba,64 as n_len from dual union all select 24 as n_num,'07002ec0' as n_dba,64 as n_len from dual union all select 25 as n_num,'07002f00' as n_dba,64 as n_len from dual union all select 26 as n_num,'07002f40' as n_dba,64 as n_len from dual union all select 27 as n_num,'07002f80' as n_dba,64 as n_len from dual union all select 28 as n_num,'07002fc0' as n_dba,64 as n_len from dual union all select 29 as n_num,'07003000' as n_dba,64 as n_len from dual union all select 30 as n_num,'07003040' as n_dba,64 as n_len from dual union all select 31 as n_num,'07003080' as n_dba,64 as n_len from dual union all select 32 as n_num,'070030c0' as n_dba,64 as n_len from dual union all select 33 as n_num,'07003100' as n_dba,64 as n_len from dual union all select 34 as n_num,'07003140' as n_dba,64 as n_len from dual union all select 35 as n_num,'07003180' as n_dba,64 as n_len from dual union all select 36 as n_num,'070031c0' as n_dba,64 as n_len from dual union all select 37 as n_num,'07003200' as n_dba,64 as n_len from dual union all select 38 as n_num,'07003240' as n_dba,64 as n_len from dual union all select 39 as n_num,'07003280' as n_dba,64 as n_len from dual union all select 40 as n_num,'070032c0' as n_dba,64 as n_len from dual union all select 41 as n_num,'07003300' as n_dba,64 as n_len from dual union all select 42 as n_num,'07003340' as n_dba,64 as n_len from dual union all select 43 as n_num,'07003380' as n_dba,64 as n_len from dual union all select 44 as n_num,'070033c0' as n_dba,64 as n_len from dual union all select 45 as n_num,'07003400' as n_dba,64 as n_len from dual union all select 46 as n_num,'07003440' as n_dba,64 as n_len from dual union all select 47 as n_num,'07003480' as n_dba,64 as n_len from dual union all select 48 as n_num,'070034c0' as n_dba,64 as n_len from dual union all select 49 as n_num,'07003500' as n_dba,64 as n_len from dual union all select 50 as n_num,'07003540' as n_dba,64 as n_len from dual union all select 51 as n_num,'07003580' as n_dba,64 as n_len from dual union all select 52 as n_num,'070035c0' as n_dba,64 as n_len from dual union all select 53 as n_num,'07003600' as n_dba,64 as n_len from dual union all select 54 as n_num,'07003640' as n_dba,64 as n_len from dual union all select 55 as n_num,'07003680' as n_dba,64 as n_len from dual union all select 56 as n_num,'070036c0' as n_dba,64 as n_len from dual union all select 57 as n_num,'07003700' as n_dba,64 as n_len from dual union all select 58 as n_num,'07003740' as n_dba,64 as n_len from dual union all select 59 as n_num,'07003780' as n_dba,64 as n_len from dual union all select 60 as n_num,'070037c0' as n_dba,64 as n_len from dual union all select 61 as n_num,'07003800' as n_dba,64 as n_len from dual union all select 62 as n_num,'07003840' as n_dba,64 as n_len from dual union all select 63 as n_num,'07003880' as n_dba,64 as n_len from dual union all select 64 as n_num,'070038c0' as n_dba,64 as n_len from dual union all select 65 as n_num,'07003900' as n_dba,64 as n_len from dual union all select 66 as n_num,'07003940' as n_dba,64 as n_len from dual union all select 67 as n_num,'07003980' as n_dba,64 as n_len from dual union all select 68 as n_num,'070039c0' as n_dba,64 as n_len from dual union all select 69 as n_num,'07003a00' as n_dba,64 as n_len from dual union all select 70 as n_num,'07003a40' as n_dba,64 as n_len from dual union all select 71 as n_num,'07003a80' as n_dba,64 as n_len from dual union all select 72 as n_num,'07003ac0' as n_dba,64 as n_len from dual union all select 73 as n_num,'07003b00' as n_dba,64 as n_len from dual union all select 74 as n_num,'07003b40' as n_dba,64 as n_len from dual union all select 75 as n_num,'07003b80' as n_dba,64 as n_len from dual union all select 76 as n_num,'07003bc0' as n_dba,64 as n_len from dual union all select 77 as n_num,'07003c00' as n_dba,64 as n_len from dual union all select 78 as n_num,'07003c40' as n_dba,64 as n_len from dual union all select 79 as n_num,'07003c80' as n_dba,64 as n_len from dual union all select 80 as n_num,'07003cc0' as n_dba,64 as n_len from dual union all select 81 as n_num,'07003d00' as n_dba,64 as n_len from dual union all select 82 as n_num,'07003d40' as n_dba,64 as n_len from dual union all select 83 as n_num,'07003d80' as n_dba,64 as n_len from dual union all select 84 as n_num,'07003dc0' as n_dba,64 as n_len from dual union all select 85 as n_num,'07003e00' as n_dba,64 as n_len from dual union all select 86 as n_num,'07003e40' as n_dba,64 as n_len from dual union all select 87 as n_num,'07003e80' as n_dba,64 as n_len from dual union all select 88 as n_num,'07003ec0' as n_dba,64 as n_len from dual union all select 89 as n_num,'07003f00' as n_dba,64 as n_len from dual union all select 90 as n_num,'07003f40' as n_dba,64 as n_len from dual union all select 91 as n_num,'07003f80' as n_dba,64 as n_len from dual union all select 92 as n_num,'07003fc0' as n_dba,64 as n_len from dual union all select 93 as n_num,'07004000' as n_dba,64 as n_len from dual union all select 94 as n_num,'07004040' as n_dba,64 as n_len from dual union all select 95 as n_num,'07004080' as n_dba,64 as n_len from dual union all select 96 as n_num,'070040c0' as n_dba,64 as n_len from dual union all select 97 as n_num,'07004100' as n_dba,64 as n_len from dual union all select 98 as n_num,'07004140' as n_dba,64 as n_len from dual union all select 99 as n_num,'07004180' as n_dba,64 as n_len from dual union all select 100 as n_num,'070041c0' as n_dba,64 as n_len from dual union all select 101 as n_num,'07004200' as n_dba,64 as n_len from dual union all select 102 as n_num,'07004240' as n_dba,64 as n_len from dual union all select 103 as n_num,'07004280' as n_dba,64 as n_len from dual union all select 104 as n_num,'070042c0' as n_dba,64 as n_len from dual union all select 105 as n_num,'07004300' as n_dba,64 as n_len from dual union all select 106 as n_num,'07004340' as n_dba,64 as n_len from dual union all select 107 as n_num,'07004380' as n_dba,64 as n_len from dual union all select 108 as n_num,'070043c0' as n_dba,64 as n_len from dual union all select 109 as n_num,'07004400' as n_dba,64 as n_len from dual union all select 110 as n_num,'07004440' as n_dba,64 as n_len from dual union all select 111 as n_num,'07004480' as n_dba,64 as n_len from dual union all select 112 as n_num,'070044c0' as n_dba,64 as n_len from dual union all select 113 as n_num,'07004500' as n_dba,64 as n_len from dual union all select 114 as n_num,'07004540' as n_dba,64 as n_len from dual union all select 115 as n_num,'07004580' as n_dba,64 as n_len from dual union all select 116 as n_num,'070045c0' as n_dba,64 as n_len from dual union all select 117 as n_num,'07004600' as n_dba,64 as n_len from dual union all select 118 as n_num,'07004640' as n_dba,64 as n_len from dual union all select 119 as n_num,'07004680' as n_dba,64 as n_len from dual union all select 120 as n_num,'070046c0' as n_dba,64 as n_len from dual union all select 121 as n_num,'07004700' as n_dba,64 as n_len from dual union all select 122 as n_num,'07004740' as n_dba,64 as n_len from dual union all select 123 as n_num,'07004780' as n_dba,64 as n_len from dual union all select 124 as n_num,'070047c0' as n_dba,64 as n_len from dual union all select 125 as n_num,'07004800' as n_dba,64 as n_len from dual union all select 126 as n_num,'07004840' as n_dba,64 as n_len from dual union all select 127 as n_num,'07004880' as n_dba,64 as n_len from dual union all select 128 as n_num,'070048c0' as n_dba,64 as n_len from dual union all select 129 as n_num,'07004900' as n_dba,64 as n_len from dual union all select 130 as n_num,'07004940' as n_dba,64 as n_len from dual union all select 131 as n_num,'07004980' as n_dba,64 as n_len from dual union all select 132 as n_num,'070049c0' as n_dba,64 as n_len from dual union all select 133 as n_num,'07004a00' as n_dba,64 as n_len from dual union all select 134 as n_num,'07004a40' as n_dba,64 as n_len from dual union all select 135 as n_num,'07004a80' as n_dba,64 as n_len from dual union all select 136 as n_num,'07004ac0' as n_dba,64 as n_len from dual union all select 137 as n_num,'07004b00' as n_dba,64 as n_len from dual union all select 138 as n_num,'07004b40' as n_dba,64 as n_len from dual union all select 139 as n_num,'07004b80' as n_dba,64 as n_len from dual union all select 140 as n_num,'07004bc0' as n_dba,64 as n_len from dual union all select 141 as n_num,'07004c00' as n_dba,128 as n_len from dual union all select 142 as n_num,'07004c80' as n_dba,256 as n_len from dual union all select 143 as n_num,'07004d80' as n_dba,256 as n_len from dual union all select 144 as n_num,'07004e80' as n_dba,256 as n_len from dual union all select 145 as n_num,'07004f80' as n_dba,256 as n_len from dual union all select 146 as n_num,'07005080' as n_dba,256 as n_len from dual union all select 147 as n_num,'07005180' as n_dba,256 as n_len from dual union all select 148 as n_num,'07005280' as n_dba,256 as n_len from dual union all select 149 as n_num,'07005380' as n_dba,256 as n_len from dual union all select 150 as n_num,'07005480' as n_dba,256 as n_len from dual union all select 151 as n_num,'07005580' as n_dba,256 as n_len from dual union all select 152 as n_num,'07005680' as n_dba,256 as n_len from dual union all select 153 as n_num,'07005780' as n_dba,256 as n_len from dual union all select 154 as n_num,'07005880' as n_dba,256 as n_len from dual union all select 155 as n_num,'07005980' as n_dba,256 as n_len from dual union all select 156 as n_num,'07005a80' as n_dba,256 as n_len from dual union all select 157 as n_num,'07005b80' as n_dba,256 as n_len from dual union all select 158 as n_num,'07005c80' as n_dba,256 as n_len from dual union all select 159 as n_num,'07005d80' as n_dba,256 as n_len from dual union all select 160 as n_num,'07005e80' as n_dba,256 as n_len from dual union all select 161 as n_num,'07005f80' as n_dba,256 as n_len from dual union all select 162 as n_num,'07006080' as n_dba,256 as n_len from dual union all select 163 as n_num,'07006180' as n_dba,256 as n_len from dual union all select 164 as n_num,'07006280' as n_dba,256 as n_len from dual union all select 165 as n_num,'07006380' as n_dba,256 as n_len from dual union all select 166 as n_num,'07006480' as n_dba,256 as n_len from dual union all select 167 as n_num,'07006580' as n_dba,256 as n_len from dual union all select 168 as n_num,'07006680' as n_dba,256 as n_len from dual union all select 169 as n_num,'07006780' as n_dba,256 as n_len from dual union all select 170 as n_num,'07006880' as n_dba,256 as n_len from dual union all select 171 as n_num,'07006980' as n_dba,256 as n_len from dual union all select 172 as n_num,'07006a80' as n_dba,256 as n_len from dual union all select 173 as n_num,'07006b80' as n_dba,256 as n_len from dual union all select 174 as n_num,'07006c80' as n_dba,256 as n_len from dual union all select 175 as n_num,'07006d80' as n_dba,256 as n_len from dual union all select 176 as n_num,'07006e80' as n_dba,256 as n_len from dual union all select 177 as n_num,'07006f80' as n_dba,256 as n_len from dual union all select 178 as n_num,'07007080' as n_dba,256 as n_len from dual union all select 179 as n_num,'07007180' as n_dba,256 as n_len from dual union all select 180 as n_num,'07007280' as n_dba,256 as n_len from dual union all select 181 as n_num,'07007380' as n_dba,256 as n_len from dual union all select 182 as n_num,'07007480' as n_dba,256 as n_len from dual union all select 183 as n_num,'07007580' as n_dba,256 as n_len from dual union all select 184 as n_num,'07007680' as n_dba,256 as n_len from dual union all select 185 as n_num,'07007780' as n_dba,256 as n_len from dual union all select 186 as n_num,'07007880' as n_dba,256 as n_len from dual union all select 187 as n_num,'07007980' as n_dba,256 as n_len from dual union all select 188 as n_num,'07007a80' as n_dba,256 as n_len from dual union all select 189 as n_num,'07007b80' as n_dba,256 as n_len from dual union all select 190 as n_num,'07007c80' as n_dba,256 as n_len from dual union all select 191 as n_num,'07007d80' as n_dba,256 as n_len from dual union all select 192 as n_num,'07007e80' as n_dba,256 as n_len from dual union all select 193 as n_num,'07007f80' as n_dba,256 as n_len from dual union all select 194 as n_num,'07008080' as n_dba,256 as n_len from dual union all select 195 as n_num,'07008180' as n_dba,256 as n_len from dual union all select 196 as n_num,'07008280' as n_dba,256 as n_len from dual union all select 197 as n_num,'07008380' as n_dba,256 as n_len from dual ), aux_temp as( select rownum n_num,n_dba L1_dba,n_dba data_dba from all_ext where n_num<=16 or mod(n_num,2)=1 ), aux_temp2 as( select n_num,L1_dba, lpad(replace(lower(to_char(to_number(data_dba,'XXXXXXXX')+1,'XXXXXXXX')),' ',''),8,'0') d_dba  from aux_temp where n_num<=16 and mod(n_num,2)=1 union all select n_num,(select L1_dba from aux_temp t where t.n_num=a.n_num-1) L1_dba,L1_dba d_dba from aux_temp a where n_num<=16 and mod(n_num,2)=0 union all select n_num,L1_dba,lpad(replace(lower(to_char(to_number(data_dba,'XXXXXXXX')+2,'XXXXXXXX')),' ',''),8,'0') from aux_temp a where n_num>16 order by 1 ) select 'm /x '||substr(L1_dba,7,2)||substr(L1_dba,5,2) ||' offset '||to_char(2736+(n_num-1)*8) from aux_temp2 where n_num>1 union all select 'm /x '||substr(L1_dba,3,2)||substr(L1_dba,1,2) ||' offset '||to_char(2736+(n_num-1)*8+2) from aux_temp2 where n_num>1 union all select 'm /x '||substr(d_dba,7,2)||substr(d_dba,5,2) ||' offset '||to_char(2736+(n_num-1)*8+4) from aux_temp2 where n_num>1 union all select 'm /x '||substr(d_dba,3,2)||substr(d_dba,1,2) ||' offset '||to_char(2736+(n_num-1)*8+6) from aux_temp2 where n_num>1; m /x 802c offset 2744 m /x 902c offset 2752 m /x 902c offset 2760 m /x a02c offset 2768 m /x a02c offset 2776 m /x b02c offset 2784 m /x b02c offset 2792 m /x c02c offset 2800 m /x c02c offset 2808 m /x d02c offset 2816 m /x d02c offset 2824 m /x e02c offset 2832 m /x e02c offset 2840 m /x f02c offset 2848 m /x f02c offset 2856 m /x 002d offset 2864 m /x 802d offset 2872 m /x 002e offset 2880 m /x 802e offset 2888 m /x 002f offset 2896 m /x 802f offset 2904 m /x 0030 offset 2912 m /x 8030 offset 2920 m /x 0031 offset 2928 m /x 8031 offset 2936 m /x 0032 offset 2944 m /x 8032 offset 2952 m /x 0033 offset 2960 m /x 8033 offset 2968 m /x 0034 offset 2976 m /x 8034 offset 2984 m /x 0035 offset 2992 m /x 8035 offset 3000 m /x 0036 offset 3008 m /x 8036 offset 3016 m /x 0037 offset 3024 m /x 8037 offset 3032 m /x 0038 offset 3040 m /x 8038 offset 3048 m /x 0039 offset 3056 m /x 8039 offset 3064 m /x 003a offset 3072 m /x 803a offset 3080 m /x 003b offset 3088 m /x 803b offset 3096 m /x 003c offset 3104 m /x 803c offset 3112 m /x 003d offset 3120 m /x 803d offset 3128 m /x 003e offset 3136 m /x 803e offset 3144 m /x 003f offset 3152 m /x 803f offset 3160 m /x 0040 offset 3168 m /x 8040 offset 3176 m /x 0041 offset 3184 m /x 8041 offset 3192 m /x 0042 offset 3200 m /x 8042 offset 3208 m /x 0043 offset 3216 m /x 8043 offset 3224 m /x 0044 offset 3232 m /x 8044 offset 3240 m /x 0045 offset 3248 m /x 8045 offset 3256 m /x 0046 offset 3264 m /x 8046 offset 3272 m /x 0047 offset 3280 m /x 8047 offset 3288 m /x 0048 offset 3296 m /x 8048 offset 3304 m /x 0049 offset 3312 m /x 8049 offset 3320 m /x 004a offset 3328 m /x 804a offset 3336 m /x 004b offset 3344 m /x 804b offset 3352 m /x 004c offset 3360 m /x 804d offset 3368 m /x 804f offset 3376 m /x 8051 offset 3384 m /x 8053 offset 3392 m /x 8055 offset 3400 m /x 8057 offset 3408 m /x 8059 offset 3416 m /x 805b offset 3424 m /x 805d offset 3432 m /x 805f offset 3440 m /x 8061 offset 3448 m /x 8063 offset 3456 m /x 8065 offset 3464 m /x 8067 offset 3472 m /x 8069 offset 3480 m /x 806b offset 3488 m /x 806d offset 3496 m /x 806f offset 3504 m /x 8071 offset 3512 m /x 8073 offset 3520 m /x 8075 offset 3528 m /x 8077 offset 3536 m /x 8079 offset 3544 m /x 807b offset 3552 m /x 807d offset 3560 m /x 807f offset 3568 m /x 8081 offset 3576 m /x 8083 offset 3584 m /x 0007 offset 2746 m /x 0007 offset 2754 m /x 0007 offset 2762 m /x 0007 offset 2770 m /x 0007 offset 2778 m /x 0007 offset 2786 m /x 0007 offset 2794 m /x 0007 offset 2802 m /x 0007 offset 2810 m /x 0007 offset 2818 m /x 0007 offset 2826 m /x 0007 offset 2834 m /x 0007 offset 2842 m /x 0007 offset 2850 m /x 0007 offset 2858 m /x 0007 offset 2866 m /x 0007 offset 2874 m /x 0007 offset 2882 m /x 0007 offset 2890 m /x 0007 offset 2898 m /x 0007 offset 2906 m /x 0007 offset 2914 m /x 0007 offset 2922 m /x 0007 offset 2930 m /x 0007 offset 2938 m /x 0007 offset 2946 m /x 0007 offset 2954 m /x 0007 offset 2962 m /x 0007 offset 2970 m /x 0007 offset 2978 m /x 0007 offset 2986 m /x 0007 offset 2994 m /x 0007 offset 3002 m /x 0007 offset 3010 m /x 0007 offset 3018 m /x 0007 offset 3026 m /x 0007 offset 3034 m /x 0007 offset 3042 m /x 0007 offset 3050 m /x 0007 offset 3058 m /x 0007 offset 3066 m /x 0007 offset 3074 m /x 0007 offset 3082 m /x 0007 offset 3090 m /x 0007 offset 3098 m /x 0007 offset 3106 m /x 0007 offset 3114 m /x 0007 offset 3122 m /x 0007 offset 3130 m /x 0007 offset 3138 m /x 0007 offset 3146 m /x 0007 offset 3154 m /x 0007 offset 3162 m /x 0007 offset 3170 m /x 0007 offset 3178 m /x 0007 offset 3186 m /x 0007 offset 3194 m /x 0007 offset 3202 m /x 0007 offset 3210 m /x 0007 offset 3218 m /x 0007 offset 3226 m /x 0007 offset 3234 m /x 0007 offset 3242 m /x 0007 offset 3250 m /x 0007 offset 3258 m /x 0007 offset 3266 m /x 0007 offset 3274 m /x 0007 offset 3282 m /x 0007 offset 3290 m /x 0007 offset 3298 m /x 0007 offset 3306 m /x 0007 offset 3314 m /x 0007 offset 3322 m /x 0007 offset 3330 m /x 0007 offset 3338 m /x 0007 offset 3346 m /x 0007 offset 3354 m /x 0007 offset 3362 m /x 0007 offset 3370 m /x 0007 offset 3378 m /x 0007 offset 3386 m /x 0007 offset 3394 m /x 0007 offset 3402 m /x 0007 offset 3410 m /x 0007 offset 3418 m /x 0007 offset 3426 m /x 0007 offset 3434 m /x 0007 offset 3442 m /x 0007 offset 3450 m /x 0007 offset 3458 m /x 0007 offset 3466 m /x 0007 offset 3474 m /x 0007 offset 3482 m /x 0007 offset 3490 m /x 0007 offset 3498 m /x 0007 offset 3506 m /x 0007 offset 3514 m /x 0007 offset 3522 m /x 0007 offset 3530 m /x 0007 offset 3538 m /x 0007 offset 3546 m /x 0007 offset 3554 m /x 0007 offset 3562 m /x 0007 offset 3570 m /x 0007 offset 3578 m /x 0007 offset 3586 m /x 882c offset 2748 m /x 912c offset 2756 m /x 982c offset 2764 m /x a12c offset 2772 m /x a82c offset 2780 m /x b12c offset 2788 m /x b82c offset 2796 m /x c12c offset 2804 m /x c82c offset 2812 m /x d12c offset 2820 m /x d82c offset 2828 m /x e12c offset 2836 m /x e82c offset 2844 m /x f12c offset 2852 m /x f82c offset 2860 m /x 022d offset 2868 m /x 822d offset 2876 m /x 022e offset 2884 m /x 822e offset 2892 m /x 022f offset 2900 m /x 822f offset 2908 m /x 0230 offset 2916 m /x 8230 offset 2924 m /x 0231 offset 2932 m /x 8231 offset 2940 m /x 0232 offset 2948 m /x 8232 offset 2956 m /x 0233 offset 2964 m /x 8233 offset 2972 m /x 0234 offset 2980 m /x 8234 offset 2988 m /x 0235 offset 2996 m /x 8235 offset 3004 m /x 0236 offset 3012 m /x 8236 offset 3020 m /x 0237 offset 3028 m /x 8237 offset 3036 m /x 0238 offset 3044 m /x 8238 offset 3052 m /x 0239 offset 3060 m /x 8239 offset 3068 m /x 023a offset 3076 m /x 823a offset 3084 m /x 023b offset 3092 m /x 823b offset 3100 m /x 023c offset 3108 m /x 823c offset 3116 m /x 023d offset 3124 m /x 823d offset 3132 m /x 023e offset 3140 m /x 823e offset 3148 m /x 023f offset 3156 m /x 823f offset 3164 m /x 0240 offset 3172 m /x 8240 offset 3180 m /x 0241 offset 3188 m /x 8241 offset 3196 m /x 0242 offset 3204 m /x 8242 offset 3212 m /x 0243 offset 3220 m /x 8243 offset 3228 m /x 0244 offset 3236 m /x 8244 offset 3244 m /x 0245 offset 3252 m /x 8245 offset 3260 m /x 0246 offset 3268 m /x 8246 offset 3276 m /x 0247 offset 3284 m /x 8247 offset 3292 m /x 0248 offset 3300 m /x 8248 offset 3308 m /x 0249 offset 3316 m /x 8249 offset 3324 m /x 024a offset 3332 m /x 824a offset 3340 m /x 024b offset 3348 m /x 824b offset 3356 m /x 024c offset 3364 m /x 824d offset 3372 m /x 824f offset 3380 m /x 8251 offset 3388 m /x 8253 offset 3396 m /x 8255 offset 3404 m /x 8257 offset 3412 m /x 8259 offset 3420 m /x 825b offset 3428 m /x 825d offset 3436 m /x 825f offset 3444 m /x 8261 offset 3452 m /x 8263 offset 3460 m /x 8265 offset 3468 m /x 8267 offset 3476 m /x 8269 offset 3484 m /x 826b offset 3492 m /x 826d offset 3500 m /x 826f offset 3508 m /x 8271 offset 3516 m /x 8273 offset 3524 m /x 8275 offset 3532 m /x 8277 offset 3540 m /x 8279 offset 3548 m /x 827b offset 3556 m /x 827d offset 3564 m /x 827f offset 3572 m /x 8281 offset 3580 m /x 8283 offset 3588 m /x 0007 offset 2750 m /x 0007 offset 2758 m /x 0007 offset 2766 m /x 0007 offset 2774 m /x 0007 offset 2782 m /x 0007 offset 2790 m /x 0007 offset 2798 m /x 0007 offset 2806 m /x 0007 offset 2814 m /x 0007 offset 2822 m /x 0007 offset 2830 m /x 0007 offset 2838 m /x 0007 offset 2846 m /x 0007 offset 2854 m /x 0007 offset 2862 m /x 0007 offset 2870 m /x 0007 offset 2878 m /x 0007 offset 2886 m /x 0007 offset 2894 m /x 0007 offset 2902 m /x 0007 offset 2910 m /x 0007 offset 2918 m /x 0007 offset 2926 m /x 0007 offset 2934 m /x 0007 offset 2942 m /x 0007 offset 2950 m /x 0007 offset 2958 m /x 0007 offset 2966 m /x 0007 offset 2974 m /x 0007 offset 2982 m /x 0007 offset 2990 m /x 0007 offset 2998 m /x 0007 offset 3006 m /x 0007 offset 3014 m /x 0007 offset 3022 m /x 0007 offset 3030 m /x 0007 offset 3038 m /x 0007 offset 3046 m /x 0007 offset 3054 m /x 0007 offset 3062 m /x 0007 offset 3070 m /x 0007 offset 3078 m /x 0007 offset 3086 m /x 0007 offset 3094 m /x 0007 offset 3102 m /x 0007 offset 3110 m /x 0007 offset 3118 m /x 0007 offset 3126 m /x 0007 offset 3134 m /x 0007 offset 3142 m /x 0007 offset 3150 m /x 0007 offset 3158 m /x 0007 offset 3166 m /x 0007 offset 3174 m /x 0007 offset 3182 m /x 0007 offset 3190 m /x 0007 offset 3198 m /x 0007 offset 3206 m /x 0007 offset 3214 m /x 0007 offset 3222 m /x 0007 offset 3230 m /x 0007 offset 3238 m /x 0007 offset 3246 m /x 0007 offset 3254 m /x 0007 offset 3262 m /x 0007 offset 3270 m /x 0007 offset 3278 m /x 0007 offset 3286 m /x 0007 offset 3294 m /x 0007 offset 3302 m /x 0007 offset 3310 m /x 0007 offset 3318 m /x 0007 offset 3326 m /x 0007 offset 3334 m /x 0007 offset 3342 m /x 0007 offset 3350 m /x 0007 offset 3358 m /x 0007 offset 3366 m /x 0007 offset 3374 m /x 0007 offset 3382 m /x 0007 offset 3390 m /x 0007 offset 3398 m /x 0007 offset 3406 m /x 0007 offset 3414 m /x 0007 offset 3422 m /x 0007 offset 3430 m /x 0007 offset 3438 m /x 0007 offset 3446 m /x 0007 offset 3454 m /x 0007 offset 3462 m /x 0007 offset 3470 m /x 0007 offset 3478 m /x 0007 offset 3486 m /x 0007 offset 3494 m /x 0007 offset 3502 m /x 0007 offset 3510 m /x 0007 offset 3518 m /x 0007 offset 3526 m /x 0007 offset 3534 m /x 0007 offset 3542 m /x 0007 offset 3550 m /x 0007 offset 3558 m /x 0007 offset 3566 m /x 0007 offset 3574 m /x 0007 offset 3582 m /x 0007 offset 3590 alter session set tracefile_identifier='zcL3_before_drop'; oradebug setmypid alter system dump datafile 28 block 11394; oradebug close_trace oradebug tracefile_name 看到如下字样       Highwater::  0x07008480  ext#: 92     blk#: 1024   ext size: 1024   也就是最大extend 是92 从0 开始也就是有 93 个 set serveroutput on DECLARE    exts number;    blocks number;   BEGIN    exts:=93;    blocks:=0;   for i in 1..exts loop   if(i<=16) then blocks := blocks + 8;   elsif(i<=63+16) then blocks := blocks + 128;   elsif(i<=120+63+16) then blocks := blocks + 1024;   else    blocks := blocks + 8192;   end if;   end loop;   dbms_output.put_line('Total blocks: '||to_char(blocks));   END;   /  22528 这些个块  --》 16进制   5800 恢复段头块ext信息 #### 参考值 ub4 extents_ech   @36    --num exts   93 --> 5d ub4 blocks_ech   @40    --num blks   5800 ub4 ext_ech       @48    --exts - 1 ub4 hwoffset_ech @68    --exts - 1 ub4 mhext_echo   @264   --exts #### d offset 36 count 12 d offset 40 count 12 d offset 48 count 12 d offset 68 count 12 d offset 264 count 12 m /x 5d offset 36 m /x 0058 offset 40 m /x 5c offset 48 m /x 5c offset 48 m /x 5d offset 264 alter system flush shared_pool; alter system flush shared_pool; alter system flush buffer_cache; alter system flush buffer_cache; select count(1) from zc.drop_1 a; set linesize 200 pagesize 999 col OWNER for a10 col segment_name for a20 select OWNER,segment_name,extent_id,file_id,block_id,blocks from dba_extents where segment_name ='DROP_1' order by extent_id;  ERROR at line 1: ORA-00600: internal error code, arguments: [25027], [3], [6], [12117], [0], [73979], [73979], [], [], [], [], [] In 12c it includes Multitenant information:      Arg [a]  0 if Multitenant is not enabled or 0 if there is not Root CDB session, 1 ROOT PDBID, otherwise PDBID top session   Arg [b]  PDBID   Arg [c]  Tablespace Number (TSN)   Arg [d]  Decimal Relative Data Block Address (RDBA) 我 bbed 改错了文件了  怀疑是这个问题 通过dba_extents构造ROWID方式获取坏块表数据: 创建新表用于存放从坏块里面扫描到的正常数据 create table zc.test_tab_normal as select * from zc.DROP_1 where 1=2; 创建错误表用于存放坏块信息 create table tt.bad_rows (row_id rowid, oracle_error_code VARCHAR2(1000)); 执行存储过程，先按extent范围进行rowid扫描，一旦遇到报错，则捕获异常转为对该extent进行逐行的rowid扫描 测试了下面的脚本 set serveroutput on DECLARE   TYPE extent_rec IS record (data_object_id number,relative_fno number,BLOCK_ID number,blocks number);   t_extent extent_rec;   bad_rows number := 0 ;   error_code number;   v_block_id number;   v_rowid rowid;   v_start_rowid rowid;   v_end_rowid rowid;   v_error_rowid rowid;   v_sql1 varchar(1000):='';   v_sql2 varchar(1000):=''; ---坏块所在的用户表名   v_table VARCHAR(30):='TESTTEST';   v_owner VARCHAR(30):='TT'; ---获取段里面每个extent里面的block_id以及block数量,extent_id=0包含段头ID，要从段头ID之后开始   CURSOR c_extent IS select b.data_object_id,a.relative_fno,c.header_block+1 start_block_id,a.blocks-(c.header_block-a.block_id+1)   from dba_extents a,dba_objects b,dba_segments c   where a.segment_name=b.object_name and a.segment_name=c.segment_name and a.owner=c.owner   and a.owner=b.owner   and b.object_name=v_table   and b.owner=v_owner   and a.extent_id=0   union all   select b.data_object_id,a.relative_fno,a.block_id start_block_id,blocks   from dba_extents a,dba_objects b   where a.segment_name=b.object_name   and a.owner=b.owner   and b.object_name=v_table   and b.owner=v_owner   and a.extent_id>0; BEGIN   OPEN c_extent;   LOOP    FETCH c_extent INTO t_extent ;    exit when c_extent%notfound;    begin  ---构造extent的最小开始rowid以及可能的最大rowid,660行是一个块里面最多存放的行数量    v_start_rowid:=dbms_rowid.rowid_create(1,t_extent.data_object_id,t_extent.relative_fno,t_extent.block_id,0);    v_end_rowid:=dbms_rowid.rowid_create(1,t_extent.data_object_id,t_extent.relative_fno,t_extent.block_id+t_extent.blocks-1,660); ---按extent进行rowid数据扫描,将正常的数据插入test_tab_normal    v_sql1:='insert into test_tab_normal select /*+ ROWID(A) */ * from '||v_owner||'.'||v_table||' A where rowid between '''||v_start_rowid||''' and '''||v_end_rowid||'''';    execute immediate v_sql1;    commit; ---如果按extent遇到报错或者查询数据失败则捕获异常转成按extent进行逐行的rowid扫描    exception     when others then ---按rowid逐行进行检索，插入 test_tab_normal        for a in 0..t_extent.blocks-1 loop       v_block_id:=t_extent.block_id+a;     for b in 0..660 loop     begin       v_rowid:=dbms_rowid.rowid_create(1,t_extent.data_object_id,t_extent.relative_fno,v_block_id,b);       v_sql2:='insert into test_tab_normal select /*+ ROWID(A) */ * from '||v_owner||'.'||v_table||' A where rowid ='''||v_rowid||'''';       execute immediate v_sql2; ---遇到坏块报错，插入bad_rows,由于是构造的rowid，可能会话插入很多的空行数据     exception       when others then         error_code:=sqlcode;         if error_code in (-1410, -8103, -1578) then           v_error_rowid:= v_rowid;           bad_rows := bad_rows + 1;           insert into bad_rows values(v_error_rowid, error_code||' block_id:'||v_block_id);           commit;         else           raise;         end if;     end;     end loop;     commit;      end loop;      commit;   END;   END LOOP;   commit;   CLOSE c_extent;   dbms_output.put_line('Total Bad Rows: '||bad_rows); END; /

参考文档：

https://www.modb.pro/db/44324