Project

General

Profile

Actions

Defect #7825

closed

open_id_authentication_associations table name too long for Oracle

Added by Matthew Rupert about 12 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2011-03-10
Due date:
% Done:

0%

Estimated time:
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 RedmineClosed2008-03-28

Actions
Actions #1

Updated by Go MAEDA about 3 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

Actions

Also available in: Atom PDF