Defect #7825

open_id_authentication_associations table name too long for Oracle

Added by Matthew Rupert over 11 years ago. Updated over 2 years ago.

Status:ClosedStart date:2011-03-10
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Database
Target version:-
Resolution:Wont fix Affected version:

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

Related to Redmine - Feature #944: Oracle Support in Redmine Closed 2008-03-28

History

#1 Updated by Go MAEDA over 2 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.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Database-Object-Names-and-Qualifiers.html#GUID-75337742-67FD-4EC0-985F-741C93D918DA

Also available in: Atom PDF