Dependency$ P_timestamp Mismatch For VALID Public Synonyms Owned By MDSYS
(Doc ID 1541636.1)
Last updated on JANUARY 16, 2020
Applies to:
Oracle Spatial and Graph - Version 11.2.0.3 and laterOracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
Symptoms
The following query
set pagesize 10000
column d_name format a20
column p_name format a20
SELECT
do.obj# d_obj,
do.name d_name,
do.type# d_type,
po.obj# p_obj,
po.name p_name,
to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') "P_Timestamp",
to_char(po.stime ,'DD-MON-YYYY HH24:MI:SS') "STIME",
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X
FROM sys.obj$ do, sys.dependency$ d, sys.obj$ po
WHERE P_OBJ#=po.obj#(+)
AND D_OBJ#=do.obj#
AND do.status=1 /*dependent is valid*/
AND po.status=1 /*parent is valid*/
AND po.stime!=p_timestamp /*parent timestamp not match*/
ORDER BY 2,1;
taken from note:
HCKW-0016 - Dependency$ p_timestamp mismatch for VALID objects (Doc ID 1361045.1)
is returning synonyms owned by MDSYS:
D_OBJ D_NAME D_TYPE P_OBJ P_NAME P_Timestamp STIME X
---------- -------------------- ---------- ---------- -------------------- -------------------- -------------------- --------
396702 /2b248550_TopoMapEdg 5 396682 /2b248550_TopoMapEdg 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
eSplit eSplit
3779831 /30492076_JGeometryV 5 3779820 /30492076_JGeometryV 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
ertex ertex
396892 /324fdcae_TopoMapWra 5 396879 /324fdcae_TopoMapWra 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
pper pper
3780190 /39b18dc9_BlobCodec 5 3780147 /39b18dc9_BlobCodec 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
396698 /3f81fc50_TopoFrame1 5 396678 /3f81fc50_TopoFrame1 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
3779835 /402ee110_J3D_Geomet 5 3779824 /402ee110_J3D_Geomet 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
ry ry
3779836 /41580df6_ElementExt 5 3779825 /41580df6_ElementExt 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
ractor ractor
3779837 /474c9b12_SdoPickler 5 3779826 /474c9b12_SdoPickler 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
UnpickleHe UnpickleHe
396705 /4dc30889_TopoMapSma 5 396685 /4dc30889_TopoMapSma 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
rtPoint rtPoint
396585 /55089d18_JGeometry 5 396581 /55089d18_JGeometry 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
3779830 /5c6ec435_JGeometryS 5 3779819 /5c6ec435_JGeometryS 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
ausage ausage
397130 /6b8ab103_Compressor 5 397115 /6b8ab103_Compressor 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
396584 /6c25142c_JGeometryE 5 396580 /6c25142c_JGeometryE 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
lementIter lementIter
3779838 /72f777cf_SdoPickler 5 3779827 /72f777cf_SdoPickler 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
396701 /77cd6977_TopoMapAlo 5 396681 /77cd6977_TopoMapAlo 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
ngSegmentC ngSegmentC
396583 /78331538_JGeometryP 5 396579 /78331538_JGeometryP 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
oint oint
396703 /7f552369_TopoMapInt 5 396683 /7f552369_TopoMapInt 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
3779828 /8eca5366_JGeometryG 5 3779817 /8eca5366_JGeometryG 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
c_trans c_trans
3780197 /906a57a7_GeorGtfPar 5 3780154 /906a57a7_GeorGtfPar 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
ser ser
3780191 /9d4abdc7_BlobDecode 5 3780148 /9d4abdc7_BlobDecode 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
Param Param
3779833 /a3a039e0_JGeometryR 5 3779822 /a3a039e0_JGeometryR 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
ing ing
3780195 /a3e12f8a_JP2Compres 5 3780152 /a3e12f8a_JP2Compres 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
sor sor
3780192 /ac0f7327_BlobImage 5 3780149 /ac0f7327_BlobImage 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
3780189 /b46e0db3_GeorJP2Int 5 3780146 /b46e0db3_GeorJP2Int 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
erface erface
3780196 /b7328870_GeoTIFFWri 5 3780153 /b7328870_GeoTIFFWri 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
ter ter
3779832 /bb41a463_JGeometryA 5 3779821 /bb41a463_JGeometryA 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
rcVertex rcVertex
396704 /c48c78e0_TopoMapPoi 5 396684 /c48c78e0_TopoMapPoi 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
ntStackEnt ntStackEnt
3780194 /ce3f022d_SISToIISAd 5 3780151 /ce3f022d_SISToIISAd 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
apter apter
396700 /d0ab1c33_TopoMapAlo 5 396680 /d0ab1c33_TopoMapAlo 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
ngEdgeComp ngEdgeComp
3779829 /e4bfb2c7_JGeometryL 5 3779818 /e4bfb2c7_JGeometryL 09-JAN-2010 21:19:10 11-MAR-2013 13:35:15 *DIFFER*
T_transfor T_transfor
3780193 /ee8e1dfc_BlobImageD 5 3780150 /ee8e1dfc_BlobImageD 09-JAN-2010 21:19:18 11-MAR-2013 13:35:28 *DIFFER*
ecoder ecoder
396893 /fb37c292_NetworkWra 5 396880 /fb37c292_NetworkWra 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
pper pper
396689 oracle/spatial/topo/ 5 396669 oracle/spatial/topo/ 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
CompGeom CompGeom
396690 oracle/spatial/topo/ 5 396670 oracle/spatial/topo/ 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
Edge Edge
396699 oracle/spatial/topo/ 5 396679 oracle/spatial/topo/ 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
TopoFrame TopoFrame
396706 oracle/spatial/topo/ 5 396686 oracle/spatial/topo/ 09-JAN-2010 21:19:11 11-MAR-2013 13:35:16 *DIFFER*
TopoMap TopoMap
36 rows selected.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |