| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> "Mysterious" objects
Playing with SYS.DEPENDENCY$ table (Oracle 7.3.2.3) I noticed several database objects dependent on some "mysterious" objects not referenced in SYS.OBJ$ table and therefore "officially" non-existent. I checked several V7.3.2.3 databases and all of them had references to these "mysterious" objects in SYS.DEPENDENCY$ table. Below is SQL I used. Does anyone have a clue?
COLUMN object_name FORMAT A30
SELECT DISTINCT object_name,
object_type,
p_obj#
FROM dba_objects,
sys.dependency$
FROM sys.obj$
WHERE obj# = p_obj#);
OBJECT_NAME OBJECT_TYPE P_OBJ#
------------------------------ ------------- ----------
ALL_ARGUMENTS VIEW 4294950942
ALL_ARGUMENTS VIEW 4294951024
ALL_CATALOG VIEW 4294950942
ALL_CATALOG VIEW 4294951024
ALL_CLUSTERS VIEW 4294950942
ALL_CLUSTER_HASH_EXPRESSIONS VIEW 4294950942
ALL_COL_COMMENTS VIEW 4294950942
ALL_COL_COMMENTS VIEW 4294951024
ALL_COL_PRIVS VIEW 4294951024
ALL_COL_PRIVS_RECD VIEW 4294951024
ALL_CONSTRAINTS VIEW 4294950942
ALL_CONSTRAINTS VIEW 4294951024
ALL_CONS_COLUMNS VIEW 4294950942
ALL_CONS_COLUMNS VIEW 4294951024
ALL_DB_LINKS VIEW 4294951024
ALL_DEPENDENCIES VIEW 4294951024
ALL_ERRORS VIEW 4294951024
ALL_HISTOGRAMS VIEW 4294950942
ALL_HISTOGRAMS VIEW 4294951024
ALL_INDEXES VIEW 4294950942
ALL_INDEXES VIEW 4294951024
ALL_IND_COLUMNS VIEW 4294950942
ALL_IND_COLUMNS VIEW 4294951024
ALL_OBJECTS VIEW 4294950942
ALL_OBJECTS VIEW 4294951024
ALL_REFRESH VIEW 4294951024
ALL_REFRESH_CHILDREN VIEW 4294951024
ALL_REPAUDIT_COLUMN VIEW 4294950942
ALL_REPAUDIT_COLUMN VIEW 4294951024
ALL_REPCOLUMN_GROUP VIEW 4294950942
ALL_REPCOLUMN_GROUP VIEW 4294951024
ALL_REPCONFLICT VIEW 4294950942
ALL_REPCONFLICT VIEW 4294951024
ALL_REPGROUPED_COLUMN VIEW 4294950942
ALL_REPGROUPED_COLUMN VIEW 4294951024
ALL_REPPARAMETER_COLUMN VIEW 4294950942
ALL_REPPARAMETER_COLUMN VIEW 4294951024
ALL_REPRESOLUTION VIEW 4294950942
ALL_REPRESOLUTION VIEW 4294951024
ALL_REPRESOLUTION_STATISTICS VIEW 4294950942
ALL_REPRESOLUTION_STATISTICS VIEW 4294951024
ALL_REPRESOL_STATS_CONTROL VIEW 4294950942
ALL_REPRESOL_STATS_CONTROL VIEW 4294951024
ALL_SEQUENCES VIEW 4294950942
ALL_SEQUENCES VIEW 4294951024
ALL_SNAPSHOTS VIEW 4294950942
ALL_SNAPSHOTS VIEW 4294951024
ALL_SOURCE VIEW 4294951024
ALL_SYNONYMS VIEW 4294950942
ALL_SYNONYMS VIEW 4294951024
ALL_TABLES VIEW 4294950942
ALL_TABLES VIEW 4294951024
ALL_TAB_COLUMNS VIEW 4294950942
ALL_TAB_COLUMNS VIEW 4294951024
ALL_TAB_COMMENTS VIEW 4294950942
ALL_TAB_COMMENTS VIEW 4294951024
ALL_TAB_PRIVS VIEW 4294951024
OBJECT_NAME OBJECT_TYPE P_OBJ#
------------------------------ ------------- ----------
ALL_TAB_PRIVS_RECD VIEW 4294951024
ALL_TRIGGERS VIEW 4294951024
ALL_TRIGGER_COLS VIEW 4294951024
ALL_UPDATABLE_COLUMNS VIEW 4294950942
ALL_UPDATABLE_COLUMNS VIEW 4294951024
ALL_VIEWS VIEW 4294950942
ALL_VIEWS VIEW 4294951024
COLUMN_PRIVILEGES VIEW 4294951024
DBA_DATA_FILES VIEW 4294950932
DBA_JOBS_RUNNING VIEW 4294950927
DBMS_ALERT PACKAGE BODY 4294950985
DBMS_REPCAT_SNA_UTL PACKAGE BODY 4294950940
DBMS_REPCAT_UTL PACKAGE BODY 4294950940
DBMS_REPCAT_UTL3 PACKAGE BODY 4294951133
DBMS_SHARED_POOL PACKAGE BODY 4294951028
DBMS_SHARED_POOL PACKAGE BODY 4294951091
DICTIONARY VIEW 4294950942
DICTIONARY VIEW 4294951024
DICT_COLUMNS VIEW 4294950942
EXU7CPO VIEW 4294951133
EXU7FIL VIEW 4294950932
EXU7FUL VIEW 4294951024
FILE_LOCK VIEW 4294951141
FILE_LOCK VIEW 4294951142
FILE_PING VIEW 4294950957
IMP7UEC VIEW 4294951125
INDEX_HISTOGRAM VIEW 4294950966
INDEX_HISTOGRAM VIEW 4294950967
INDEX_STATS VIEW 4294950966
LOADER_COL_INFO VIEW 4294950942
LOADER_COL_INFO VIEW 4294951024
LOADER_CONSTRAINT_INFO VIEW 4294950942
LOADER_CONSTRAINT_INFO VIEW 4294951024
LOADER_FILE_TS VIEW 4294950932
LOADER_INDCOL_INFO VIEW 4294950942
LOADER_INDCOL_INFO VIEW 4294951024
LOADER_IND_INFO VIEW 4294950942
LOADER_IND_INFO VIEW 4294951024
LOADER_PARAM_INFO VIEW 4294950940
LOADER_TAB_INFO VIEW 4294950942
LOADER_TAB_INFO VIEW 4294951024
LOADER_TRIGGER_INFO VIEW 4294950942
LOADER_TRIGGER_INFO VIEW 4294951024
NLS_INSTANCE_PARAMETERS VIEW 4294950940
NLS_SESSION_PARAMETERS VIEW 4294951071
ORA_KGLR7_DEPENDENCIES VIEW 4294951024
ORA_KGLR7_DEPENDENCIES VIEW 4294951084
ORA_KGLR7_IDL_CHAR VIEW 4294951024
ORA_KGLR7_IDL_SB4 VIEW 4294951024
ORA_KGLR7_IDL_UB1 VIEW 4294951024
ORA_KGLR7_IDL_UB2 VIEW 4294951024
ORA_KGLR7_OBJECTS VIEW 4294951084
PRODUCT_COMPONENT_VERSION VIEW 4294951045
ROLE_ROLE_PRIVS VIEW 4294951023
ROLE_SYS_PRIVS VIEW 4294951023
ROLE_TAB_PRIVS VIEW 4294951023
SESSION_PRIVS VIEW 4294950942
OBJECT_NAME OBJECT_TYPE P_OBJ#
------------------------------ ------------- ----------
SESSION_ROLES VIEW 4294951024
SYSCATALOG_ VIEW 4294950942
SYSFILES VIEW 4294950932
TABLE_PRIVILEGES VIEW 4294951024
USER_FREE_SPACE VIEW 4294950942
USER_ROLE_PRIVS VIEW 4294951023
USER_TABLESPACES VIEW 4294950942
V$BH VIEW 4294950954
V$KXSBD VIEW 4294951196
V$LOCK_ACTIVITY VIEW 4294950959
V$LOCK_ELEMENT VIEW 4294950958
V$XATRANS$ VIEW 4294951052
V_$ACCESS VIEW 4294950931
V_$ACTIVE_INSTANCES VIEW 4294951195
V_$ARCHIVE VIEW 4294950933
V_$BACKUP VIEW 4294951076
V_$BGPROCESS VIEW 4294950918
V_$CIRCUIT VIEW 4294950948
V_$COMPATIBILITY VIEW 4294951125
V_$COMPATSEG VIEW 4294951126
V_$CONTROLFILE VIEW 4294951111
V_$DATABASE VIEW 4294951047
V_$DATAFILE VIEW 4294951050
V_$DBFILE VIEW 4294950932
V_$DBLINK VIEW 4294951157
V_$DB_OBJECT_CACHE VIEW 4294951091
V_$DB_PIPES VIEW 4294951143
V_$DISPATCHER VIEW 4294950944
V_$ENABLEDPRIVS VIEW 4294950942
V_$EVENT_NAME VIEW 4294951104
V_$EXECUTION VIEW 4294951144
V_$FILESTAT VIEW 4294950934
V_$FIXED_TABLE VIEW 4294951084
V_$FIXED_VIEW_DEFINITION VIEW 4294951152
V_$INDEXED_FIXED_COLUMN VIEW 4294951151
V_$INSTANCE VIEW 4294951066
V_$LATCH VIEW 4294950921
V_$LATCHHOLDER VIEW 4294950923
V_$LATCHNAME VIEW 4294950922
V_$LATCH_CHILDREN VIEW 4294951168
V_$LATCH_MISSES VIEW 4294951186
V_$LATCH_PARENT VIEW 4294951169
V_$LIBRARYCACHE VIEW 4294950951
V_$LICENSE VIEW 4294951083
V_$LOADCSTAT VIEW 4294950949
V_$LOADTSTAT VIEW 4294950950
V_$LOCK VIEW 4294950927
V_$LOCKED_OBJECT VIEW 4294951181
V_$LOG VIEW 4294951049
V_$LOGFILE VIEW 4294950935
V_$LOGHIST VIEW 4294951051
V_$LOG_HISTORY VIEW 4294951077
V_$MLS_PARAMETERS VIEW 4294950940
V_$MTS VIEW 4294951093
V_$MYSTAT VIEW 4294951107
V_$NLS_PARAMETERS VIEW 4294951071
V_$NLS_VALID_VALUES VIEW 4294951131
OBJECT_NAME OBJECT_TYPE P_OBJ#
------------------------------ ------------- ----------
V_$OBJECT_DEPENDENCY VIEW 4294951154
V_$OPEN_CURSOR VIEW 4294951092
V_$OPTION VIEW 4294951133
V_$PARAMETER VIEW 4294950940
V_$PQ_SESSTAT VIEW 4294951138
V_$PQ_SLAVE VIEW 4294951137
V_$PQ_SYSSTAT VIEW 4294951139
V_$PQ_TQSTAT VIEW 4294951190
V_$PROCESS VIEW 4294950917
V_$PWFILE_USERS VIEW 4294951116
V_$QUEUE VIEW 4294950946
V_$RECOVERY_FILE_STATUS VIEW 4294951165
V_$RECOVERY_LOG VIEW 4294951078
V_$RECOVERY_STATUS VIEW 4294951164
V_$RECOVER_FILE VIEW 4294951075
V_$REQDIST VIEW 4294950947
V_$RESOURCE VIEW 4294950925
V_$ROLLNAME VIEW 4294951022
V_$ROLLSTAT VIEW 4294950937
V_$ROWCACHE VIEW 4294950916
V_$SESSION VIEW 4294950919
V_$SESSION_CONNECT_INFO VIEW 4294951159
V_$SESSION_CURSOR_CACHE VIEW 4294951088
V_$SESSION_EVENT VIEW 4294951103
V_$SESSION_WAIT VIEW 4294951097
V_$SESSTAT VIEW 4294950928
V_$SESS_IO VIEW 4294951080
V_$SGA VIEW 4294950938
V_$SGASTAT VIEW 4294950939
V_$SHARED_POOL_RESERVED VIEW 4294951171
V_$SHARED_SERVER VIEW 4294950945
V_$SORT_SEGMENT VIEW 4294951177
V_$SQL VIEW 4294951148
V_$SQLAREA VIEW 4294951028
V_$SQLTEXT VIEW 4294951090
V_$SQLTEXT_WITH_NEWLINES VIEW 4294951153
V_$SQL_BIND_DATA VIEW 4294951203
V_$SQL_BIND_METADATA VIEW 4294951202
V_$SQL_CURSOR VIEW 4294951201
V_$SQL_SHARED_MEMORY VIEW 4294951194
V_$STATNAME VIEW 4294950930
V_$SYSSTAT VIEW 4294950929
V_$SYSTEM_CURSOR_CACHE VIEW 4294951089
V_$SYSTEM_EVENT VIEW 4294951101
V_$SYSTEM_PARAMETER VIEW 4294951200
V_$THREAD VIEW 4294951048
V_$TIMER VIEW 4294951068
V_$TRANSACTION VIEW 4294950920
V_$TYPE_SIZE VIEW 4294951070
V_$VERSION VIEW 4294951045
V_$WAITSTAT VIEW 4294950915
V_$_LOCK VIEW 4294950926
Solomon Yakobson
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Aug 04 1997 - 00:00:00 CDT
 |
 |