Hi Anders,
USER_SDO_GEOM_METADATA is a view off the MDSYS table, filtered for the
current users permissions.
system@orcl> set long 1000
system@orcl> select text from dba_views where
view_name='USER_SDO_GEOM_METADATA';
TEXT
----------------------------------------------------------------------------
----
SELECT SDO_TABLE_NAME TABLE_NAME,
SDO_COLUMN_NAME COLUMN_NAME,
SDO_DIMINFO DIMINFO,
SDO_SRID SRID
FROM SDO_GEOM_METADATA_TABLE
WHERE sdo_owner = sys_context('userenv', 'CURRENT_SCHEMA')
system@orcl>
But when you create a spatial table/view in a schema, you need to add a
record into USER_SDO_GEOM_METADATA in that schema. The insert flows through
the view into the underlying MDSYS table.
Regards, Paul
From: Erlandsson Anders [mailto:[email protected]]
Sent: Tuesday, 28 June 2011 9:48 PM
To: Harikumar Reddy; Miles Jordan
Cc: [email protected]
Subject: Re: [Geoserver-users] Problems with SDO_POINT geometries from
Oracle [SEC=Unclassified] 11.2 [SEC=Unclassified]
Hi,
and thanks for your answers!
I have an empty USER_SDO_GEOM_METADATA table. Might this be the problem? The
"tables" I would like to use are actually views. Do I need to manually
"register" them as spatial when creating the views, so I get records in
USER_SDO_GEOM_METADATA table?
The Schema that holds the source table with points, does not seem to have an
USER_SDO_GEOM_METADATA table at all. When I look into
MDSYS.SDO_GEOM_METADATA_TABLE, there are several rows pointing to the source
tables but none for the views.
Kind regards
Anders Erlandsson
GIS-engineer
Sundsvalls kommun
Stadsbyggnadskontoret
_____
Från: Harikumar Reddy [mailto:[email protected]]
Skickat: den 9 juni 2011 08:27
Till: Miles Jordan
Kopia: Erlandsson Anders; [email protected]
Ämne: Re: [Geoserver-users] Problems with SDO_POINT geometries from Oracle
[SEC=Unclassified] 11.2 [SEC=Unclassified]
Hi Miles,
It is most common error occurred for us too (inform DBA to fix metadata &
Spatial Index problems), when imported different types of geodata to into
oracle tables. The metadata (Spatial extent or bounding box of the gis layer
present in oracle tables) is not updated after geodata import.
Try to install Georaptor in sqldeveloper (its added as a plugin to
sqldeveloper) and update metadata and check for spatial indexes created?
other wise it will error as OCIIndexerror. After this process, geoserver
You can install Georaptor in sqldeveloper as given below
Open sqldeveloper and click on help, check for updates, A new window will
open with welcome, source, updates, sownload, summary links in the lefthand
side. click next and source is highlighted, click add button and give
Georaptor as name and http://georaptor.sourceforge.net/install.xml url as
location. click next till end.
after the process, restart your sqldeveloper and when you right click, you
can find Georaptor as an option, by clicking manage metadata, it will open
new window with bounding box default parameters (which are not correct).
click on calibrate MBR and then click on update and close.
I hope that this solves your problem.
Regards,
Hari.
On Thu, Jun 9, 2011 at 5:57 AM, Miles Jordan <[email protected]>
wrote:
If it doesnt show up in the layers list then the most likely cause is a
missing entry in USER_SDO_GEOM_METADATA. Try logging into SQL Developer with
the same user and double check if the table is listed in there properly.
-Miles
From: Erlandsson Anders
I have a lot of 2D point tables that does not show up in the available
Layers list when trying to publish a new layer. 3D layers of the same
dataset shows fine and the only difference I can see in the two tables are
the GTYPE, that is set to 2001 for the 2D-data and 3001 for the 3D-data. I
have tried to select records using SQL Developer with the same user account
as in Geoserver, and it works fine.
Any suggestions on what might be wrong?
___________________________________________________________________________
Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are
not the
intended recipient, you are notified that use or dissemination of this
communication is
strictly prohibited by Commonwealth law. If you have received this
transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232
3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________
----------------------------------------------------------------------------
--
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
