Question: Using galaxy with Oracle database?
gravatar for fiebig
2.6 years ago by
fiebig30 wrote:


lately I tried to connect our local Galaxy instance to our Oracle 12c database. I managed to establish the connection and the first table "migrate_version" was created in the schema. Then the setup was canceled with the message, that the "table identifier is to long."

Indeed Oracle table names, column names ect. have a maximum length of 30 characters. Some of the Galaxy sqlite table names exceed that limit, example table: "cleanup_event_library_dataset_association" (41 characters).

Is there anybody who actively uses an Oracle DB together with Galaxy?!? Every hint/solution/howto is appreciated. At the moment I'm under the impression, that it is not possible to use Oracle DBs.

Greetings, Anne

galaxy oracle • 755 views
ADD COMMENTlink modified 2.6 years ago by Bjoern Gruening5.1k • written 2.6 years ago by fiebig30
gravatar for Jennifer Hillman Jackson
2.6 years ago by
United States
Jennifer Hillman Jackson25k wrote:

Hello Anne,

I do not know of any groups using Oracle with Galaxy. The recommended database choices are included here, Section 3.2:

Others that have used Oracle with Galaxy successfully are welcome to post!

Best, Jen, Galaxy team

ADD COMMENTlink written 2.6 years ago by Jennifer Hillman Jackson25k
gravatar for Bjoern Gruening
2.6 years ago by
Bjoern Gruening5.1k
Bjoern Gruening5.1k wrote:

Not really related but an interesting read:

If you can stay away from Oracle ;)

ADD COMMENTlink written 2.6 years ago by Bjoern Gruening5.1k

hmm, somehow I expected this answer. Integrating the Galaxy DB in the institutes main DB, curated by an DBA would have been very comfortable. Oracle rules are sometimes a bit creepy (MVs)...ok, I'm going to inform about Postgresql.

ADD REPLYlink written 2.6 years ago by fiebig30
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 172 users visited in the last hour