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.