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


Popular posts from this blog

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

ORA-01153: an incompatible media recovery is active standby database oracle

ORA-16191: Primary log shipping client not logged on standby