Article - CS185243

Oracle import before upgrade returns "IMP-00015: following statement failed because the object already exists" in Windchill PDMLink

Modified: 28-Jan-2016   


Applies To

  • Windchill PDMLink 6.2 to 11.0

Description

  • Import of dump file during upgrade returns:
    • IMP-00015: following statement failed because the object already exists:
       "CREATE PACKAGE WipPK IS"
       "FUNCTION getNormalizedWipState(state VARCHAR2) RETURN NUMBER DETERMINISTIC;"
       "END WipPK;"
      IMP-00015: following statement failed because the object already exists:
       "CREATE PACKAGE WTReversePK IS"
       "FUNCTION ReverseChars(p_value IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC;"
       "END WTReversePK;"
  • Legacy imp/exp is being used instead of data pump due to:
    • https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS73598
This is a printer-friendly version of Article 185243 and may be out of date. For the latest version click CS185243