Dependency$ P_timestamp Mismatch For VALID Public Synonyms Owned By MDSYS

Last updated on FEBRUARY 08, 2017

Applies to:

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