SQL> col file_name for a40
SQL> select file_name,tablespace_name,bytes/1024/1024 "M" from dba_data_files;
FILE_NAME TABLESPACE_NAME M
---------------------------------------- ------------------------------ ----------
+DG1/rac/datafile/users.259.783018573 USERS 5
+DG1/rac/datafile/sysaux.257.783018569 SYSAUX 270
+DG1/rac/datafile/undotbs1.258.783018571 UNDOTBS1 30
+DG1/rac/datafile/system.256.783018565 SYSTEM 480
+DG1/rac/datafile/example.264.783018999 EXAMPLE 100
+DG1/rac/datafile/undotbs2.265.783019457 UNDOTBS2 25
[oracle@rac-one ~]$ dbv file='+DG1/rac/datafile/example.264.783018999' userid=root/098765
DBVERIFY: Release 10.2.0.1.0 - Production on Sat Nov 10 00:25:41 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = +DG1/rac/datafile/example.264.783018999
DBVERIFY - Verification complete
Total Pages Examined : 12800
Total Pages Processed (Data) : 4409
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 1264
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1539
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 5588
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 0 (0.0)
阅读(2875) | 评论(0) | 转发(0) |
