Recuperar el status invalid de un objeto

[yong321]

PROY.DOM_SEQ is a synonym pointing to a non-existing object OBJY.DOM_SEQ. Create OBJY.DOM_SEQ as a sequence and you'll be able to run either of the following two:

select PROY.DOM_SEQ.nextval from dual;
select OBJY.DOM_SEQ.nextval from dual;