I have enabled a constraint and rebuilt an bitmap indexe (Oracle
8i). After this I noticed that I had several Packages and Procs
that were invalid. By doing this should these proc become
invalid ???

Answer:

Check whether the underlying table is being referred to by the procedures
and packages by checking user_dependencies. As soon as anything changes and
the object is being used in pl/sql the pl/sql object becomes invalid.
However, as soon as you call the pl/sql object it will automatically
recompile.

Hth,

Sybrand Bakker, Oracle DBA