check for the status of the object
using dba_objects table...

regards
anandkl