Project

General

Profile

Bug #5717

Oracle does not allow table names greater than 30 characters

Added by ben leinfelder about 7 years ago. Updated about 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 about 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 about 7 years ago

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

#3 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 5717

Also available in: Atom PDF