Description:
During the migration procedure, the "reverse engenering" step fails each time i try to migrate datas, either if the source Oracle database is empty or not !
What should I do?
Many thanks in advance!
How to repeat:
Here's the error message encountered each time :
Initializing JDBC driver ...
Driver class oracle.jdbc.OracleDriver
Opening connection ...
Connection jdbc:oracle:thin:ops$gverspou/gverspou@ondh9023:1521:eth
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for OPS$GVERSPOU.
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?, 'ESTIMATE', 50, 0, 'FOR TABLE')
Fetch the number of tables in the schema OPS$GVERSPOU.
SELECT COUNT(*) AS TABLECOUNT FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME
Fetching 0 table(s) of the schema OPS$GVERSPOU.
SELECT * FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME
Fetch all views of the schema OPS$GVERSPOU.
SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c WHERE v.OWNER=? AND c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V'ORDER BY v.OWNER, v.VIEW_NAME
The schema could not be reverse engineered (error: 0).
ORA-00942: table or view does not exist
Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineerProcedures(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineer(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)