select * from T_LOG_ONLINE t1 where   ((t1.SETTLE_DATE < '20130101' AND t1.RESV_FLD4 IS NULL )
                OR t1.SETTLE_DATE = '20130101')   AND t1.REVSAL_FLAG IS NULL
                AND t1.CANCEL_FLAG IS NULL AND t1.pay_org_code = '004110000000000'
ora-01114

SQL> select owner,segment_name,tablespace_id,header_file,header_block from sys_dba_segs where segment_name='T_LOG_ONLINE_PAYMENT_HIS';

OWNER SEGMENT_NAME TABLESPACE_ID HEADER_FILE HEADER_BLOCK
------------------------------ --------------------------------------------------------------------------------- ------------- ----------- ------------
BTUPAYPROD T_LOG_ONLINE_PAYMENT_HIS 75 282 249995\

耗时很长
/u01>dbv userid=user/passwd segment_id=75.282.249995

DBVERIFY: Release 10.2.0.4.0 - Production on Fri Jan 18 11:09:24 2013

DBVERIFY - Verification starting : SEGMENT_ID = 75.282.249995

DBVERIFY - Verification complete

Total Pages Examined         : 901120
Total Pages Processed (Data) : 897203
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1364
Total Pages Processed (Seg) : 1
Total Pages Failing   (Seg) : 0
Total Pages Empty            : 2552
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0
Highest block SCN            : 1280222243 (4.1280222243)
[oracle@spayrdb1]/u01>                                date
Fri Jan 18 11:17:56 GMT+08:00 2013

ITPub博客

ora-01114---dbv

最新文章