Database Administration (MOSC)

MOSC Banner

V$ARCHIVED_LOG has object_type of 'NEXT OBJECT' in dba_objects following upgrade to 11.1.0.6.0

edited Dec 16, 2008 9:44PM in Database Administration (MOSC) 1 commentAnswered
 Following an upgrade from 9.2.0.8 to 11.1.0.6.0, which did not produce any errors in the log files, a query in dba_objects where object_name in ('V_$ARCHIVED_LOG','V$ARCHIVED_LOG') produces the following

OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME

SYS V$ARCHIVED_LOG 0 0 NEXT OBJECT 0000-00-00:00:00:00 INVALID N N N 1
SYS V_$ARCHIVED_LOG 656 VIEW 22/07/2002 08:00:29 15/12/2008 14:32:56 2008-12-08:11:49:29 INVALID N N N 1 ORA$BASE
PUBLIC V$ARCHIVED_LOG 657 SYNONYM 15/12/2008 13:46:39 15/12/2008 13:46:39 2008-12-15:13:46:39 VALID N N N 1 ORA$BASE
 

3 rows selected.

A query from V$ARCHIVED_LOG works and the view V_$ARCHIVED_LOG then shows as valid for a short time before becoming invalid again.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center