Details

      Description

      Basically, Oracle can have more then one schema inside it.

      exo-jcr doesn't manage this case and if we try to connect differents exo-instance with different schema under the same DB
      we will get this e oracle error "ORA-00942: table or view does not exist"

      this problem will returned when the table or view exists but is in a different schema from the current schema where the SQL is executing
      (in other word, the table doesn't own by the user1, but owned by other another user user2), the oracle ORA-00942 error will returned.

      This problem can be Resolved by explicitly reference the table or view by specifying the schema name, i.e. schema_name.table_name.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                nzamosenchuk Nikolazy Zamosenchuk
                Reporter:
                zaouiahmed ahmed zaoui
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day, 4 hours Original Estimate - 1 day, 4 hours
                  1d 4h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 week
                  1w