由于oracle错误604,ora 604的解决过程

今天社区报告error：

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)

at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:118)

at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:466)

at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:413)

at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:432)

at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:182)

at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:165)

at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:608)

at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:489)

at cirrus.hibernate.impl.SessionFactoryImpl.getPreparedStatement(SessionFactoryImpl.java:483)

at cirrus.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:50)

at cirrus.hibernate.loader.Loader.prepareQueryStatement(Loader.java:417)

at cirrus.hibernate.loader.Loader.doFind(Loader.java:145)

at cirrus.hibernate.loader.Loader.loadEntity(Loader.java:491)

at cirrus.hibernate.loader.EntityLoader.load(EntityLoader.java:65)

at cirrus.hibernate.persister.EntityPersister.load(EntityPersister.java:420)

at cirrus.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:1554)

at cirrus.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1425)

at cirrus.hibernate.impl.SessionImpl.load(SessionImpl.java:1363)

at com.netease.club.persist.hibe.DAOSupport.load(DAOSupport.java:68)

Caused by: java.sql.SQLException: ORA-00604: R SQL B 1 ?ORA-01000:

鶶8

'p

ORA-00604: R SQL B 1 ?ORA-01000:

鶶8

'p

ORA-01000:

鶶8

'p

网上查后发现以下解决方法：

Your table SDO_GEOM_METADATA_TABLE (part of Oracle Spatial) not present in the DB or is corrupted.

FIX -

Run the script catmd.sql (located in $ORACLE_HOME/md/admin dir).

The catmd.sql script is the script that loads all objects needed by Oracle spatial in the

database.

运行catmd.sql后正常