Using DBMS_SPACE_ADMIN to manage LMT's

[nabaig]

Fellow DBA's,

I have just completed implementing LMT's in my org and felt that I need to train myself using DBMS_SPACE_ADMIN package.

Other than the Package reference doc, where can I get more info about using them?

More specifically, these procedures call for arguments like:

DBMS_SPACE_ADMIN.SEGMENT_VERIFY (
tablespace_name IN VARCHAR2,
header_relative_file IN POSITIVE,
header_block IN POSITIVE,
verify_option IN POSITIVE DEFAULT SEGMENT_VERIFY_EXTENTS);

How do I determine the header block or relative file values?

Thanks,
Nizar

[pando]

from dba_segments

lsc@MOVE>desc dba_segments
 Name                                                              Null?    Type
 ----------------------------------------------------------------- -------- ------------------------
 OWNER                                                                      VARCHAR2(30)
 SEGMENT_NAME                                                               VARCHAR2(81)
 PARTITION_NAME                                                             VARCHAR2(30)
 SEGMENT_TYPE                                                               VARCHAR2(18)
 TABLESPACE_NAME                                                            VARCHAR2(30)
 HEADER_FILE                                                                NUMBER
 HEADER_BLOCK                                                               NUMBER
 BYTES                                                                      NUMBER
 BLOCKS                                                                     NUMBER
 EXTENTS                                                                    NUMBER
 INITIAL_EXTENT                                                             NUMBER
 NEXT_EXTENT                                                                NUMBER
 MIN_EXTENTS                                                                NUMBER
 MAX_EXTENTS                                                                NUMBER
 PCT_INCREASE                                                               NUMBER
 FREELISTS                                                                  NUMBER
 FREELIST_GROUPS                                                            NUMBER
 RELATIVE_FNO                                                               NUMBER
 BUFFER_POOL                                                                VARCHAR2(7)

[nabaig]

Pando,

Thank you.

I ran these procedures and got the message "Statement processed).

I am assuming that no corruptions or anomalies are present in my bitmaps.

If there are and needs to be fixed, how/where will I get the appropriate messages.

Thnaks,

Nizar