I couldn't figure out exactly how one can use TS_OPTION for the above mentioned procedure. What are the difference in functionality of each options?
Below is the description from oracle documentation. First option is clear from the description, other two is ambiguous. I also noticed that a "note" was intended for each option from (1),(2) and (3), but there is no such notes present.
Any help appreciated -
TABLESPACE_VERIFY_BITMAPS: The bitmaps are verified against the extents. This will detect bits that are marked used or free wrongly and will also detect multiple allocation of extents. The file metadata will be validated against file$ and control file. This is the default option (1).
TABLESPACE_VERIFY_DEEP: This option is used to verify the file bitmaps as well perform checks on all the segments (2).
TABLESPACE_VERIFY_SEGMENTS: This option is used to invoke SEGMENT_VERIFY on all the segments in the tablespace. Optionally the user can write a script that queries all the segments in the tablespace and invoke SEGMENT_VERIFY(3).
Thanks, Dhimant Patel.