Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚÁ½Ì¨²»Í¬µÄ»úÆ÷Éϰ²×°ÅäÖÃArcSDE £¨oracle£©

ʹÓÃsdeupgradeora9iÓ¦ÓóÌÐòÉý¼¶ºó£¬ÔÙ°´ÕÕÒ»°ãµÄpost·½·¨post,ÔÚÌîдnet service nameʱ£¬Ê¹ÓÃoracle¿Í»§¶ËµÄ net manager ÅäÖÃÒ»¸öÁíһ̨oracleÊý¾Ý¿âµÄservice name;ÆäÓà°´ÕÕ Ò»°ã·½·¨½øÐУ¬PostÍê³Éºó£¬ÐÞ¸Ä$sdehome/dbinit.sde
 set ORACLE_SID = ORCL;Ϊ
set LOCLA=service name;
Æô¶¯·þÎñ¼´¿É¡£


Ïà¹ØÎĵµ£º

Oracle EBS ÈçºÎÔ½áÖ®Ó¦¸¶(AP)¶ÔÕËÏê½â

Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄÜ¹Ø±Õ»á¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑ­ÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......

Çø±ðoracleµÄµ¥ÒýºÅºÍË«ÒýºÅ

      ¶ÔÓÚÎÒÃǸÕÈëÃŵÄoracle³õѧÕßÀ´Ëµ£¬Ñ§Ï°sqlÓïÑÔÊÇÈëÃŵĵÚÒ»²½£¬Ãæ¶Ôµ¥ÒýºÅºÍË«ÒýºÅ£¬ÎÒÃÇ¿ÉÄÜ»áÀ§»ó£¬Ê²Ã´Ê±ºòÓõ¥ÒýºÅ£¬Ê²Ã´Ê±ºòÓÃË«ÒýºÅÄØ£¿
    µ¥ÒýºÅ------  ֵΪ×Ö·ûºÍÈÕÆÚµÄʱºò Èç  'you'  '06-june'   »¹ÓÐʹÓÃÁ¬½Ó·û||£¬²åÈë¿Õ¸ñ||' ......

ÌáÈ¡Oracleµ±Ç°Óû§Ãû£¬»úÆ÷Ãû£¬IPµÄ·½·¨

select sysdate  µ±Ç°Ê±¼ä,
       sys.login_user  Êý¾Ý¿âÓû§,
       machine   µÇ¼»úÆ÷Ãû,
       SYS_CONTEXT('USERENV', 'IP_ADDRESS')   µÇ¼IP,
     &n ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ