Thursday, May 8, 2008

ArcSDE register Oracle Spatial

Hi Friends,
here is the procedure to register the oracle spatial to ArcSDE.
1. insert to metadata into user_sdo_geom_metadata view by using the following syntax.
"insert into user_sdo_geom_metadata (TABLE_NAME,COLUMN_NAME,DIMINFO, SRID) values ('" & strnewtablename & "','GEOM',SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', minx, maxX, 0.005),SDO_DIM_ELEMENT('Y', miny, maxy, 0.005)),SRID(enter ur SRID Number))"
2. create the spatial index on the table.
3. run the following command at the SDE server.
sdelayer -o register -e p3 -l TABLE_NAME,COLUMN_NAME-C DBID,USER -u oracleUserName -p oraclePassword.

please let us know if you any problems.

Thank You,
GIS programmers.

5 comments:

Anonymous said...

Hi! I simply would like to offer you a huge thumbs up for the great information you've got right here on this post. I'll be returning
to your web site for more soon.

my website: satellite cs

Anonymous said...

I have read so many posts regarding the blogger lovers except this article is truly a good paragraph, keep it
up.

Look into my blog post - Cccam Dreambox

Anonymous said...

Greetings I am so excited I found your webpage,
I really found you by mistake, while I was looking on Digg for something else, Nonetheless I am here now and would just like to say many thanks for a remarkable post
and a all round entertaining blog (I also love the theme/design), I don’t have time to go through it all at the moment
but I have book-marked it and also included your RSS feeds, so
when I have time I will be back to read a great deal more,
Please do keep up the great work.

Also visit my web-site :: http://www.satellitecardsharing.com/openbox-s10-hd-2/

Anonymous said...

You can definitely see your expertise within the work you write.
The world hopes for more passionate writers such as you who aren't afraid to mention how they believe. All the time follow your heart.

Here is my page; Premium Cardsharing

Anonymous said...

I want to to thank you for this fantastic read!! I absolutely loved every bit of it.
I have got you saved as a favorite to check out new stuff you post…

Feel free to surf to my webpage - premium card Share service