search

schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.6k stars 199 forks source link

TABLE_COLUMNS.sql not working for Oracle 11g #162

Closed uppalabharath closed 6 years ago

uppalabharath commented 6 years ago

Environment

Windows schemacrawler-14.19.01-distribution Database: Oracle 11g Driver: ojdbc6

Issue

The table_columns.sql query is added with a new column named IDENTITY_COLUMN that is specific to Oracle 12c DB. As the column is missing in older versions of Oracle DB, the query fails with an ora 00904 invalid identifier error.

My 2 cents: Try to hit the 12c Query first if it fails, fallback to the older query where 'NO' as is_autoincrement is used in place of IDENTITY_COLUMN as is_autoincrement

schemacrawler commented 6 years ago

Thanks . Oracle 11g has ended its support lifetime. Oracle 12c was introduced in 2013. SchemaCrawler will not support Oracle 11g. I understand that your organization may still be using Oracle 11g, though. You may need to write your own plugin for SchemaCrawler, or see if you can use DatabaseSpecificOverrideOptionsBuilder to change the table column retrieval strategy.

sualeh commented 6 years ago

Please use SchemaCrawler 14.21.01, which supports Oracle 11g and Oracle 12c.