liquibase Oracle ORA-00942

0
votes

when calling liquibase migrate, generatechangelog, etc... with an Oracle database , we allways get the ORA-00942 error when liquibase calls the oracle jdbcdriver for metadata

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
1
oracleliquibase
............................................... – Tony Nys
I suggest you to improve your example by reading the Minimal, Complete and verifiable example. – IlGala

1 Answers

2
votes

Found the issue by tracing the logging in the ojdbc_g driver. It turns out that getSchemas() in the jdbcdriver queries ´ALL_USERS` view in Oracle

DatabaseMetaData metadata=conn.getMetaData(); ResultSet rs2=metadata.getSchemas();

SELECT username AS table_schem,null as table_catalog FROM all_users ORDER BY table_schem ORA-00942: table or view does not exist

In our database, ALL_USERS view does not exist, so I created the view again in the standard Oracle way

CREATE OR REPLACE FORCE VIEW "ALL_USERS" ("USERNAME", "USER_ID", "CREATED") ...