java.sql.SQLException

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table ORA-02063: preceding line from DB-LINK-NAME

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 web12529

  • via Oracle Community by 603540, 11 months ago
    ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table ORA-02063: preceding line from DB-LINK-NAME
  • via Oracle Community by 666705, 1 year ago
    ORA-01445: cannot select ROWID from a join view without a key-preserved table
  • via Oracle Community by 843859, 1 year ago
    ORA-01008: not all variables bound ORA-02063: preceding line from MYLINK
  • Stack trace

    • java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table ORA-02063: preceding line from DB-LINK-NAME at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383) at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:701) at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:235) at oracle.sdovis.Theme.prepareData(Theme.java:184) at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)

    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

    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    76 more bugmates