Recuperar el status invalid de un objeto

[general9000]

ORACLE version 11.1.0.7 g

estaba revisando la lista de objetos invalidos de dba_objects

SQL > select owner,object_name,status from dba_objects where object_name='DOM_SEQ'

owner object_name status
PROY DOM_SEQ INVALID

=============================================

se me ocurrio hacerle un desc

SQL > desc PROY.DOM_SEQ
ERROR:
ORA-04043: object "OBJY"."DOM_SEQ" does not exist

=========================================

al volver a consultar el mismo objeto el status cambió a VALID !

SQL > select owner,object_name,status from dba_objects where object_name='DOM_SEQ'

owner object_name status
PROY DOM_SEQ VALID

================================================== =
Verifico que la secuencia no existe:

SQL > select PROY.DOM_SEQ.currval from dual;
select PROY.DOM_SEQ.currval from dual
*
ERROR at line 1:
ORA-02289: sequence does not exist

=======================================


Como puedo hacer para recuperar el estado INVALID de éste
objeto que NO Existe !! :(

gracias.

[8vio]

Hola

Intenta con:

ALTER SYSTEM CHECKPOINT;

Saludos,

[general9000]

Iniciado por 8vio

Hola

Intenta con:

ALTER SYSTEM CHECKPOINT;

Saludos,

gracias por contestar pero como lo haria individualmente OBJeto por 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;