ÅäÖöà¸öSDE·þÎñ(oracle)
ÅäÖöà¸öSDE·þÎñ(oracle) ÏîĿҪ׼±¸Á½·ÝÏàͬ½á¹¹µÄÊý¾Ý¸ø²»Í¬µÄÓû§£¬ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó£¬²»¶ÏµÄ±¸·Ý»¹ÔЧÂÊÊ®·ÖµÍÏ£¬Òò´Ë¿¼ÂÇн¨Ò»¸öÊý¾Ý¿â£¬½¨Á¢Á½¸öSDE·þÎñ¡£
1.н¨Êý¾Ý¿âDXGX_GX(ÔÊý¾Ý¿â£ºDXGX)
2.ÔËÐÐSDE POST д´½¨Ò»¸ö·þÎñ£¨ÔÚ´´½¨Ö®Ç°ÐèÒªÏȹرÕÒÑÔÚÔËÐÐÖеÄSDE·þÎñ£©
3.ÔÚArcCatalogÀィÁ¢ÐµÄSDEÁ¬½ÓDXGXGX£¨ÒÔÇ°µÄ½ÐDXGX£©¡£
ÎÊÌâ³öÏÖÁË£¬Á½¸öSDE·þÎñDXGXGXºÍDXGXµÄÄÚÈÝÍêÈ«Ò»Ñù£¬¶¼ÊÇÁ¬½Ó±íDXGX_GXµÄ±í¿Õ¼äSDE¡£
½â¾ö°ì·¨£º
1.ÕÒµ½SDEHOMEĿ¼(¿ÉÒÔÔڲ˵¥-ÔËÐÐÀïÊäÈ룺%SDEHOME%)
2.¸´ÖÆÎļþ¼ÐϵÄËùÓеÄÎļþµ½ÐµÄĿ¼£¬ÈçC:\ArcGIS\ArcSDE\ora9iexe2.
3.´ò¿ªÔĿ¼ÖеÄ%SDEHOME%\etc\dbinit.sdeÎļþ£¬ÐÞ¸Ä set ORACLE_SID=DXGXGX Ϊ set ORACLE_SID=DXGX ±£´æ
4.´ò¿ª×¢²á±í£ºHKEY_LOCAL_MACHINE\SOFTWARE\ESRI\ArcInfo\ArcSDE\ArcSDE for Oracle ´ò¿ªÐ½¨µÄSDE·þÎñ£¬Èçesri_gxsde,ÐÞ¸Ä×Ó¼üSDEHOMEΪ²½Öè2ÖÐи´ÖƵÄĿ¼¡£
5.ÖØÆôÁ½¸öSDE·þÎñ¼´¿É£¡
ÔÒò£ºdbinit.sdeÎļþ¼Ç¼ÁËÊý¾Ý¿âµÄSID£¬Ð½¨SDE·þÎñʱ£¬°ÑÔÀ´SDE·þÎñËùÖ¸ÏòµÄÊý¾Ý¿âSIDÒ²¸ü¸ÄÁË£¡
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/gisfarmer/archive/2009/04/24/4103712.aspx
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÎÊÌ⣺Êý¾Ý¿âΪ£ºOracle Database 10g Release 2
¡¡¡¡²Ù×÷ϵͳΪ£ºWindows Vista/Windows XP MCE(Á½¸ö²Ù×÷ϵͳ·Ö±ð°²×°ºó³öÏÖÏàͬÎÊÌâ)
¡¡¡¡Êý¾Ý¿â°²×°ºó(һ·ĬÈÏÖµ)£¬³¢ÊÔInsertÊý¾ÝºóSelect³öÀ´£¬ÔÀ´µÄÖÐÎÄ×Ö¶ÎÖµ±ä³ÉÁË??????ÐÎʽµÄÂÒÂ룬¸ÃÈçºÎ½â¾ö£¿
¡¡¡¡ÔÚÍøÉϲéÁËһЩ×ÊÁÏ£¬ËµÊÇ·þÎñÆ÷Óë¿Í»§¶Ë×Ö·û¼¯²»Æ¥Å䣬µ«Î ......
ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
ALTER TABLE ±íÃû rename column ÁÐÃû to ÐÂÁÐÃû ×¢ÒâcolumnÊǹؼü×Ö /*ÖØÃüÃûÁÐÃû*/
ALTE ......
OracleÓû§½âËø
¡¡¡¡Ã¿µ±ÎÒÃÇа²×°ÁËoracleºó,µÚÒ»´ÎÔËÐж¼»á³öÏÖÒ»¸öÓû§±»ËøµÄ´íÎóÌáʾ,´ËʱÐèÒªÎÒÃÇÊÖ¶¯½øÐÐÓû§½âËø,ÏÂÃæÒÔ½âËøscottÓû§ÎªÀý: Ê×ÏÈÔÚÃüÁîÐд°¿ÚÖÐÊäÈë sqlplus sys/sys as sysdba ÕâÀïµÄsysÊÇϵͳÕ˺Å,oracle×Ô´øµÄ,ºóÃæµÄsysÊÇÃÜÂë,Õâ¸öÃÜÂëÔÚÄ㰲װʱÉèÖúõÄ. as sysdba Òâ˼¾ÍÊÇÒÔÕâ¸öÓû§×öΪÊý ......
½ñÌìÔÚ°Ù¶ÈÉÏËÑË÷ÁËÏÂoracleдµÄ´¥·¢Æ÷£¬¸Ð¾õ»¹¿ÉÒÔ¡£
¾ÍÊղؿ©¡£
Óû§±í£º´´½¨´¥·¢Æ÷֮ǰÊ×ÏÈÒª´´½¨ÐòÁÐ
Óû§±íÐòÁУº
create sequence users_seq;
Óû§±í´¥·¢Æ÷£º
create or replace trigger bifer_users_userid_pk
before insert
on users
for each row
begin
select users_seq.nextval into:new.userid from ......