Project

General

Profile

Bug #5717

Oracle does not allow table names greater than 30 characters

Added by ben leinfelder over 7 years ago. Updated over 7 years ago.

Status:
Resolved
Priority:
Normal
Category:
metacat
Target version:
Start date:
09/21/2012
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
5717

Description

I'm trying to get metacat configured and get errors when running the upgrade-db-to-2.0.0-oracle.sql. I think I can resolve all the issues but two because of an Oracle limitation. The script has the following create statements:

CREATE TABLE systemMetadataReplicationPolicy...
CREATE TABLE systemMetadataReplicationStatus...

Both these names violate Oracle's 30 character limit for table names (they are both 31 chars). Is there any work around for this issue?

Thanks,

Parrish Martin
U.S. Army Corps of Engineers

(904) 232-2616

History

#1 Updated by ben leinfelder over 7 years ago

The changes for this are in trunk now and targeted for our next release (2.0.5)

#2 Updated by ben leinfelder over 7 years ago

The DataONE project that depends on these names has also been updated.

#3 Updated by Redmine Admin about 7 years ago

Original Bugzilla ID was 5717

Also available in: Atom PDF