Project

General

Profile

Actions
Copy link

Bug #5717

closed

Oracle does not allow table names greater than 30 characters

Added by ben leinfelder over 12 years ago. Updated about 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
ben leinfelder
Category:
metacat
Target version:
2.0.5
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
Copy link
 #1

Updated by ben leinfelder about 12 years ago

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

Actions
Copy link
 #2

Updated by ben leinfelder about 12 years ago

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

Actions
Copy link
 #3

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 5717

Actions
Copy link

Also available in: Atom PDF