Defect #7825
closed
open_id_authentication_associations table name too long for Oracle
0%
Description
Oracle table names are limited to 30 characters. When doing a db migrate to an Oracle db this creates the error below.
AddOpenIdAuthenticationTables: migrating ================================-- create_table(:open_id_authentication_associations, {:force=>true})
rake aborted!
An error has occurred, all later migrations canceled:
OCIError: ORA-00972: identifier is too long: CREATE TABLE "OPEN_ID_AUTHENTICATION_ASSOCIATIONS" ("ID" NUMBER NOT NULL PRIMARY KEY, "ISSUED" NUMBER, "LIFETIME" NUMBER, "HANDLE" VARCHAR2, "ASSOC_TYPE" VARCHAR2, "SERVER_URL" BLOB, "SECRET" BLOB)
/opt/redmine-1.1.2/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1077:in `log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:493:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_schema_statements.rb:84:in `create_table'
Related issues
Updated by Go MAEDA almost 5 years ago
- Status changed from New to Closed
- Resolution set to Wont fix
Matthew Rupert wrote:
Oracle table names are limited to 30 characters. When doing a db migrate to an Oracle db this creates the error below.
I am not sure if the current version of Redmine works with Oracle, but the maximum length of table names is 128 bytes in Oracle 12.2 or higher.