Thursday, 3 January 2013

how to use dbverify tool in Oracle


select tablespace_name, segment_name, TABLESPACE_ID, HEADER_FILE, HEADER_BLOCK
from sys.sys_user_segs
where tablespace_name='USERS' and SEGMENT_NAME like 'JUNK%';

dbv file=/ora_data/oracle/data/common_data.dbf   LOGFILE=common_data.log   feedback=200

No comments:

Post a Comment