ÅäÖöà¸ö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 ......
¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order by salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition by deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......
ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
ALTER TABLE ±íÃû rename column ÁÐÃû to ÐÂÁÐÃû ×¢ÒâcolumnÊǹؼü×Ö /*ÖØÃüÃûÁÐÃû*/
ALTE ......
¶ÔÓÚÎÒÃǸÕÈëÃŵÄoracle³õѧÕßÀ´Ëµ£¬Ñ§Ï°sqlÓïÑÔÊÇÈëÃŵĵÚÒ»²½£¬Ãæ¶Ôµ¥ÒýºÅºÍË«ÒýºÅ£¬ÎÒÃÇ¿ÉÄÜ»áÀ§»ó£¬Ê²Ã´Ê±ºòÓõ¥ÒýºÅ£¬Ê²Ã´Ê±ºòÓÃË«ÒýºÅÄØ£¿
µ¥ÒýºÅ------ ֵΪ×Ö·ûºÍÈÕÆÚµÄʱºò Èç 'you' '06-june' »¹ÓÐʹÓÃÁ¬½Ó·û||£¬²åÈë¿Õ¸ñ||' ......
´¦Àí·½·¨Ò» £º
¼ì²éÄǸö±í±»Ëø
select sess.sid,sess.serial#, lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;
½âËø
alter system kill session '273,45';
´¦Àí·½·¨¶ ......