oracle shell±à³ÌʲôÒâ˼°¡£¿ÊDz»ÊǾʹ洢¹ý³ÌʲôµÄ°¡£¿
°Ù¶Èһϣ¬Äã»á¸üÇå³þ¡£¡£¡£¡£
http://www.oracle.com/technology/global/cn/pub/articles/saternos_scripting.html
Shell ½Å±¾ÊÇʲô£¿
shell ½Å±¾ÊÇÒ»¸ö°üº¬ÃüÁîÐòÁеÄÎı¾Îļþ¡£µ±ÔËÐÐÎļþ£¨»ò½Å±¾£©Ê±£¬½«Ö´ÐиÃÎļþÖаüº¬µÄÃüÁî¡£ÊõÓï shell ½ ......
ÓÐÕâÑùµÄÈýÕÅ±í£¬¼Ç¼±í£¨id£¬compid µ¥Î»±àºÅ£¬happentime ·¢Éúʱ¼ä£¬protypeid ÎÊÌâÀàÐÍ£©£¬ÎÊÌâÀàÐÍ±í£¨proid,¡¡)£¬µ¥
λ±í(compidµ¥Î»±àºÅ£¬compnameµ¥Î»Ãû³Æ£©¡£
Òª×öÒ»ÏÂÈýÖÖͳ¼Æ£º
Ò»£ºÍ³¼ÆÄ³Ò»Ê±¼ä¶ÎÄÚijµ¥Î»²»Í¬ÎÊÌâµÄ»ã×ÜÇé¿ö
Ñ¡ÔñºÃ¾ßÌ嵥룬Æðʼʱ¼ä¡¢½ØÖ¹Ê±¼ä
Éú³ÉÒ»ÏÂÕâÑùµÄ½á¹û£º
......
ÎÒµÄOracle·þÎñ¶ËµÄ°æ±¾ÊÇ10.1.0µÄ£¬Ëü×°ÔÚÁËÐéÄâ»úÀϵͳÊÇwin2003¡£
¿Í»§¶Ë×°ÔÚXPÀï°æ±¾ÊÇ10.2.0µÄ£¬ÇëÎÊÊDz»ÊÇÁ½¸ö°æ±¾¶¼ÒªÍêȫһÖ°¡£¿£¿
¿Í»§¶Ë¿ÉÒԱȷþÎñ¶Ë°æ±¾¸ß£¬µ«ÊÇ·þÎñÆ÷²»Äܱȿͻ§¶Ë°æ±¾¸ß
¸ß°æ±¾µÄ¿Í»§¶Ë²»ÄÜÖ±½Ó´ÓµÍ°æ±¾µÄ·þÎñÆ÷ÖÐÖ±½Óµ¼³ö dmpÊý¾Ý
1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ± ......
oracle10G·þÎñÆ÷
oracleµÄËùÓзþÎñ¶¼±»ÎҸijÉÊÖ¶¯
µ±ÎÒÆô¶¯DBCONSOLEºóÔÙÆô¶¯listener
ÔòÁ½¸ö·þÎñͬʱ×Ô¶¯¹Ø±Õ
ÎÒÓõÄÊDZ¾±¾£¬¹«Ë¾ÉÏÁË»áÍø£¬»Ø¼ÒÒ²ÉÏÁË»áÍø£¬ÊÇÕâ¸öÓ°ÏìµÄÂð£¿
ÏÈÆô¶¯listener£¬ÔÙÆô¶¯instance£¬ÔÙÆô¶¯dbconsole£¬Èç¹û»¹ÕâÑù£¬¿ÉÄÜÓë»ú×ÓµÄipÓйØ
×Ö×ÖÖéçá
......
ÎÒÏëÔÚdatawindow´°ÌåµÄd_test_mk ÀïÃæµÄSQLÓï¾äдÌõÅжÏÓï¾ä
if ...........then
............
end if
ÕâÑùдÊÇͨ²»¹ýµÄ ÔÓï¾äΪ
if (select count(1) from PORT_ORDER where ORDERNO = '0910000004')>0 then
insert into PORT_ORDER values
('0910000 ......
ÎÊÌâÊÇÕâÑùµÄ
ÎÒoracle°²×°ÓÐÒ»¶Îʱ¼äÁË£¬dosÉϵÄsqlplusÓÃÁ˺ÜÕý³££¬µ«ÊÇä¯ÀÀÆ÷·ÃÎÊÄÇÀïÓò»ÁË£¬¸Õ¸Õ²âÊÔ
http://localhost:5560²âÊÔ5560¶Ë¿Ú£¬½á¹ûÊÇû±»Õ¼ÓÃ
ËùÒÔSQLplusÎÒ»ú×ÓÉÏÓò»ÁË
ÇëÎÊÊÇÔõÑùÈÃSQLplusÕ¼ÓÃÕâ¸ö¶Ë¿ÚµÄ£¬È»ºóÄØ£¬ÎÒÏëÊÔÒ»ÊÔ¿ÉÊÓ»¯½çÃæ
·þÎñÆô¶¯Ã»£¿
c:>emctl sta ......