8 Replies Latest reply: Feb 24, 2014 1:49 PM by Laury RSS

    Getting started with Oracle Spatial on Oracle RDBMS 12c

    Laury

      Hi,

       

      I have an Oracle RDBMS 12cR1 SE.

      Oracle Spatial is a special feature in an Oracle database to store "spatial/geographic" in a relational model structure.

       

      My questions are the following:

       

      1) In my registry I have SDO (Spatial) with status OPTION OFF. This means that this feature is not enabled for usage. How can I enable it? Does it also apply for SE?

       

      2) When the SDO (Spatial) is enabled, I can store "spatial/geographic" data in my database.

      What tool can I use to create this data? What tool can I use to graphically view this data (maps, diagrams, volumes,...)?

       

      Thank by advance for any feedback.

       

      Kind Regards.

        • 1. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
          Srini Chavali-Oracle

          Spatial is only available in the EE version - you cannot enable it in the SE version - it is typically installed by default in the EE version - Oracle Database Editions

           

          For loading spatial data - pl see examples - Loading Spatial Data

           

          HTH
          Srini

          • 2. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
            Siva Ravada

            On SE, there is a subset of Spatial functionality called Locator.

            That will give you the ability to store spatial data in the database.

             

            See the link for more details:

            Oracle Spatial and Graph Learn More

            • 3. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
              Laury

              Thanks for the answer, and my apologies for the delay.

              1) What is the difference between the full Spatial functionality (for EE) and the Locator (for SE)?

              2) When I have Spatial data, what tool can I use to "view" this data on a "graphical" way?

               

              Thanks and Regards.

              • 4. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
                Emad Al-Mousa

                To Answer you question in details:

                 

                1. the difference between Oracle Locator and Oracle Spatial:

                 

                Oracle Locator: a feature of Oracle Database (Standard and Enterprise Editions), provides core location functionality needed by most customer applications and partner solutions. (Locator is not a solution for complex GIS applications .)  Developers can extend existing Oracle-based applications, since with Locator they can easily incorporate location information directly in their applications and services. This is possible because location data is fully integrated in the Oracle server itself. Geographic and location data are manipulated using the same semantics applied to the CHAR, DATE or INTEGER types that are familiar to all users of SQL.

                 

                 

                 

                Oracle Spatial: an option to Oracle Database Enterprise Edition, augments Locator, and provides a robust foundation for complex GIS applications which require more spatial analysis and processing in Oracle Database. It includes spatial functions (including area, buffer, centroid calculations), advanced coordinate systems support, linear referencing system, and aggregate functions. Significant new capabilities in this release address the challenging business-critical requirements from the public sector, defense, logistics, energy exploration, and business geographics domains.

                 

                2. to check if oracle spatial component is installed and "valid" in your database use the following query: SELECT COMP_NAME,VERSION,STATUS FROM DBA_REGISTRY;

                 

                3. when you have spatial data stored in your database, you can view it using "Oracle Fusion Middleware MapViewer":http://www.oracle.com/technetwork/middleware/mapviewer/overview/index.html

                 

                OR

                 

                you can integrate your Oracle Spatial data with ESRI ArcGIS software and view the data in their ArcGIS Desktop , this requires registering the oracle spatial data with ArcGIS, this paper is very good paper to read: http://download.oracle.com/otndocs/products/spatial/pdf/spatial_wp09_bestprac.pdf

                 

                i hope this gives some insight.

                • 5. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
                  B Hall

                  FYI,

                   

                  ESRI / ArcGIS with Oracle 12c using SDO_GEOMETRY (why would you use anything else) - according to some co-workers who just returned from a conference, is not officially supported until 10.3. In addition, ESRI support has told us that 11.2.0.4 is also not supported until 10.3, although my co-workers asked this at the conference and were told it was no big deal. So take that as you want I guess. Of course we learned all of this AFTER we upgraded from 11.2.0.3 to 11.2.0.4, since it was not documented any place that we have noted on their site. Yeah...

                   

                  Anyhow, if you choose to use their software - you only need locator since they don't take advantage of any significant spatial database functionality with their software abstraction architecture model. Which is a great shame, since that is such an inefficient model. You end up retrieving and moving many times more data between the database and application than is required. We have had our GIS support staff ask us why x takes 20 seconds to finish. After analysis, Oracle actually did all the work in a fraction of a second, but their app ate up the rest of the time parsing and displaying it. High performance and ESRI should never be used in the same sentence. If you have a small dataset, it is probably fine. If you have billions of rows, forget it.

                   

                  I'd personally look at open source based solutions before considering any of their products as I'd had much better support with lower cost.

                   

                  My $.02

                   

                  Bryan

                  • 6. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
                    Emad Al-Mousa

                    @B Hall

                     

                    yes you are correct, i was mistaken regarding the certification environment level.

                     

                    ESRI ArcGIS 10.2.2 (their latest release) is certified with Oracle 11.2.0.4 only not 12c

                    • 7. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
                      Laury

                      Hi Emad,

                       

                      My great thnaks to you, and my apologies for the delay in answering...

                      Yes, this is good information and I will start some readings.

                       

                      Kind Regards.

                      • 8. Re: Getting started with Oracle Spatial on Oracle RDBMS 12c
                        Laury

                        Hi Bryan,

                         

                        My great thanks to you as well, and my apologies for the delay...

                        Open source seems a good option to start... Do you hve any indication as an open source to view and create themes and maps?

                         

                        Kind Regards.