Hi,
I have a few suggestions:
- "Schema" field in the datastore settings page works perfectly for us and
filters out all the system tables. We have a datamanager account who owns all
our spatial tables and views and a Geoserver user who may publish the data if
datamanager allows it.
- First aid is to use the Search tool and you do not need to browse through all
the tables.
Long table list is not really any performance problem. Tables are not
automatically published to anybody, you can just see the list with the
administration utility.
-Jukka Rahkonen-
________________________________
Lähettäjä: marwa El-said [mailto:melsaid2...@hotmail.com]
Lähetetty: 12. lokakuuta 2010 11:09
Vastaanottaja: joyc...@hotmail.com;
geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] many tables isted while creating oracle
data store
yea, i think so
because all those tables i really don't care about them and may affect
on the performance of retrieving tables because of the huge number of tables
that will be retreived from oracle data store with each user
I wanna a way to eleminate this because i'm searching my tables between
hundreds of tables to bublish my layers
if there are any permissions i can give to my user, please tell me
about.
I tried Create session, select any table, connect, Resource and no way
to stop that
waiting for your reply
and thanks for help
Regards,
Marwa Elsaid
________________________________
From: joyc...@hotmail.com
To: andrea.a...@geo-solutions.it
Date: Tue, 12 Oct 2010 11:24:17 +1100
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] many tables isted while creating oracle
data store
> Nothing funny with that. People want to publish also geometryless
tables with WFS
> occasionally, so we list everything we find.
It's usual with Oracle to filter out all the system tables, since by
default a user can see a lot of them, but they are rarely useful to an
application end user. If you make an Oracle connection with ESRI, Intergraph,
etc, they filter out tables owned by SYS, SYSTEM, MDSYS, XDB, etc, plus tables
with names containing $, tables ending in _SDOGEOM, etc, etc.
What do you think, should GeoServer also filter out the system tables?
An option on the data store?
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports standards for
HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and
rewriting code and more time creating great experiences on the web. Be a part
of the beta today. http://p.sf.net/sfu/beautyoftheweb
_______________________________________________ Geoserver-users mailing
list Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
