oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException

ORA-02303: cannot drop or replace a type with type or table dependents

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web153

  • via Oracle Community by muneer.ngha.ksa, 11 months ago
    ORA-02303: cannot drop or replace a type with type or table dependents
  • via Oracle Community by 581663, 1 year ago
    ORA-00942: table or view does not exist
  • via Oracle Community by 438033, 1 year ago
    ORA-00942: table or view does not exist
  • Stack trace

    • oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-02303: cannot drop or replace a type with type or table dependents at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1000) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380) at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:511) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:229) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.