Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-45387

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

    XMLWordPrintable

Details

    • 2
    • 3
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? 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: