oracle损坏记录查询

oracle损坏记录查询 SQL> select tablespace_name,segment_type,owner,segment_name from dba_extents 2 where file_id=11 3 and 63096 between block_id AND block_id + block_id -1 4 ; TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE GOV_SENDFILECHECKWITHWF_ACC USERS TABLE EZOFFICE GOV_SENDFILENOBROWSER USERS TABLE EZOFFICE GOV_SENDFILE_USER TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE OA_INFORMATION USERS TABLE EZOFFICE OA_INFORMATIONBROWSER USERS TABLE EZOFFICE OA_INFORMATIONHISTORY TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE OA_MAILACCESSORY USERS TABLE EZOFFICE OA_MAILINTERIOR USERS TABLE EZOFFICE OA_MAILINTERIOR TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE OA_MAILINTERIOR USERS TABLE EZOFFICE OA_MAILINTERIOR USERS TABLE EZOFFICE OA_MAILINTERIOR TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE OA_MAIL_USER USERS TABLE EZOFFICE WF_DEALWITH USERS TABLE EZOFFICE WF_DEALWITHCOMMENT TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_DEALWITHCOMMENT USERS TABLE EZOFFICE WF_PROCEEDACTIVITY USERS TABLE EZOFFICE WF_PROCEEDACTIVITY TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDACTIVITY USERS TABLE EZOFFICE WF_PROCEEDACTIVITY USERS TABLE EZOFFICE WF_PROCEEDACTIVITY TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDACTIVITY USERS TABLE EZOFFICE WF_PROCEEDFLOW USERS TABLE EZOFFICE WF_PROCEEDFLOW TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDREADWRITECONTROL USERS TABLE EZOFFICE WF_PROCEEDTR TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_PROCEEDTRANSITION USERS TABLE EZOFFICE WF_PROCEEDTRANSITION USERS TABLE EZOFFICE WF_WORK TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE WF_WORK TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE WF_WORK TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE WF_WORK TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS TABLE EZOFFICE WF_WORK USERS TABLE EZOFFICE T1200 USERS LOBINDEX EZOFFICE SYS_IL0000030651C00007$$ TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS INDEX EZOFFICE PK_GOV_SENDFILECHECKWITHWF_ACC USERS INDEX EZOFFICE PK_GOV_SENDFILECHECKWITHWORKFL USERS INDEX EZOFFICE SYS_C003248 TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS INDEX EZOFFICE SYS_C003248 USERS INDEX EZOFFICE PK_OA_INFORMATIONBROWSER USERS INDEX EZOFFICE PK_OA_MAILACCESSORY TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS LOBINDEX EZOFFICE SYS_IL0000031080C00005$$ USERS INDEX EZOFFICE PK_OA_MAIL_USER USERS INDEX EZOFFICE PK_ORG_SYNCRTX TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS INDEX EZOFFICE PK_WF_DEALWITHCOMMENT USERS INDEX EZOFFICE PK_WF_PROCEEDACTIVITY USERS INDEX EZOFFICE SYS_C004424 TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS INDEX EZOFFICE SYS_C004424 USERS INDEX EZOFFICE PK_WF_PROCEEDREADWRITECONTROL USERS INDEX EZOFFICE PK_WF_PROCEEDREADWRITECONTROL TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS INDEX EZOFFICE PK_WF_PROCEEDREADWRITECONTROL USERS INDEX EZOFFICE PK_WF_PROCEEDREADWRITECONTROL USERS INDEX EZOFFICE PK_WF_PROCEEDREADWRITECONTROL TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS INDEX EZOFFICE PK_WF_PROCEEDREADWRITECONTROL USERS INDEX EZOFFICE PK_WF_WORK USERS LOBSEGMENT EZOFFICE SYS_LOB0000030651C00007$$ TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS LOBSEGMENT EZOFFICE SYS_LOB0000030651C00007$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000030651C00007$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000030651C00007$$ TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS LOBSEGMENT EZOFFICE SYS_LOB0000031038C00014$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000031038C00014$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000031038C00014$$ TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS LOBSEGMENT EZOFFICE SYS_LOB0000031038C00014$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000031038C00014$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000031052C00006$$ TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS LOBSEGMENT EZOFFICE SYS_LOB0000031080C00005$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000031080C00005$$ USERS LOBSEGMENT EZOFFICE SYS_LOB0000031080C00005$$ TABLESPACE_NAME SEGMENT_TYPE OWNER ------------------------------ ------------------ ------------------------------ SEGMENT_NAME ----------------------------------------------------------- --------------------- USERS LOBSEGMENT EZOFFICE SYS_LOB0000032051C00007$$ 已选择85行。 SQL> spool off;