Project

General

Profile

Actions
Copy link

Bug #5717

closed

Oracle does not allow table names greater than 30 characters

Added by ben leinfelder about 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

Also available in: Atom PDF