Project

General

Profile

Actions

Bug #5717

closed

Oracle does not allow table names greater than 30 characters

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

Actions #1

Updated by ben leinfelder over 11 years ago

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

Actions #2

Updated by ben leinfelder over 11 years ago

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

Actions #3

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 5717

Actions

Also available in: Atom PDF