Hello,
Excuse me for this
maybe dummy question, I am new at Oracle and coming from Sybase world, I
subscribed to this list 1 week ago. If my question is answered somewhere in
archived place, please feel free to direct me to this place.
I am looking for
Oracle built-in tools to check/verify consistency of the db/tables/indexes
etc...
Sybase provides a
set of tools to verify/check/repair the database/tables/indexes logical and
physical consistency called dbcc .
This will allow to
check allocation structures , page and object linkage (sybase page is equivalent
to an oracle block and an object is a table,index,view...).
To say that in
Oracle words, the tools will verify that the oracle block(s)/extent(s) which are
allocated to an object is/are effectively allocated to this object and that
the different blocks/extents(s) are correctly linked
together.
Does this make sense
to you ?
Thanks,
Maya
