Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-45387

Add official support to the usage of a different schema on Oracle

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      According to our official documentation, Oracle databases should always use the schema owned by the user JIRA uses to connect with the system, not allowing for a different schema to be specified for the usage of another user's schema.

      Manually adding the schema-name property to dbconfig.xml leads to problems with indexes, which are created (by default) under the schema of the user JIRA is using for the connection. Then, at some point, JIRA tries to create those indexes under the schema its database is on, which fails with a ORA-00955 (object already exists) error.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jpalharini Joao Palharini (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: