¼×¹ÇÎÄÍÆ³ö¡°Oracle¼Ó¿ì¼Æ»®¡±
¶þÁãÁã¾ÅÄêʮԶþÊ®ÈÕ£¬´ò´ÓÈýÄêÇ°ÍÆ³öOracle¼Ó½ô¼Æ»®ÒÔÀ´£¬¼×¹ÇÎĹ«Ë¾ÒѾÔö¼ÓÁËÆß,000¶à¼ÒÖÎÀíÈí¼þÖÐÐÍÆóÒµ¿Í»§£¬µ±Ç°ÖÐÐÍÆóÒµ¿Í»§×ÜÁ¿ÒѾ³¬¹ý25,000¼Ò¡£
͸¹ýÍÆ³öÂíÏòÖÐÐÍÆóÒµ¿Í»§µÄOracle¼Ó¿ì¼Æ»®Ð¹¦ÄÜ£¬°üÀ¨ÐÂʽ¼Ó¿ì¼Æ»®½â¾ö·½°¸¡¢OracleÆóÒµ¼ÓËÙÆ÷¡¢²ÆÎñÑ¡¼þºÍµ÷¶È²½ÖèµÈ£¬¼×¹ÇÎÄÔÚ²»Í£¶ÒÏÖ˳Àû¡£
ÃæÁÙÖÐÐÍÆóÒµµÄOracle¼Ó½ô¼Æ»®£¬¼ÓÉÏÓµÓÐÌØ¶¨ÐÐÒµºÍÇøÓòÖ§Åä¼¼ÊõµÄOracleÓ¦ÓÃÈí¼þºÍÒµÎñ¼ÓËÙÆ÷£¬¿Éͨ¹ý¸ß¶ÈÕë¶ÔÐԺ͸ßËÙÖ§ÅäÈí¼þ°ü½â¾öºÜ¶àÒµÎñÎÊÌâ¡£OracleÆóÒµ¼ÓËÙÆ÷ ÊǸö¿É¸ßËÙÊ©ÐеŤ¾ß£¬¾¹ý¼×¹ÇÎÄΪºÏ×÷»ï°éÌṩģ°æºÍ¾ßÓÐÐÐÒµ¼°ÇøÓòÕë¶ÔÐÔµÄÕ¼ÏÈʵ¼ù´¦ÖÃÁ÷³Ì£¬À´¼«´óµØ¼õСִÐÐʱ¼ä¡¢¼õµÍ¸´ÔÓ¶È¡¢Àϱ¾Å¯·çÏÕ¡£
³ýÍ⣬Oracle¼Ó½ô¼Æ»®»¹ÍƳöÁËÒ»¸öеÄÃŵÚÍøÕ¾--midsize.oracle.com¡£ËüÊÇÒ»¸ö×ÊԴƽ̨ҲÊÇÒ»¸öºÏ×÷ƽ̨£¬Ä¿µÄÊÇΪÁ˱ãÀûÖÐÐÍÆóÒµ¿Í»§ºÍºÏ×÷»ï°éÕÒѰÓÐÇøÓòºÍÐÐÒµÕë¶ÔÐԵĽâ¾ö·½°¸¡£
й¦ÄÜ
¼×¹ÇÎĹ«Ë¾µ±Ç°ÍƳöµÄÐÂOracle¼Ó½ô½â¾ö·½°¸°üÀ¨Ã³Ò×ÖÇÄÜ¡¢Æó¹¦ÒµÐ§ÖÎÀíÒÔ¼°ÍйÜÐÍCRM¡£
Óë´Ëͬʱ£¬¼×¹ÇÎÄ»¹ÁªÊÖHPÍÆ³öÁËÕë¶Ô²úÒµÖÆÔìÒµµÄHPºÍOracle×Éѯ¼Ó¿ì½â¾ö·½°¸¡£
¼×¹ÇÎÄ»¹¶ÒÏÖÁË¶ÔÆóÒµ¼ÓËÙÆ÷¹¤¾ßÌ×¼þµÄÀ©³ä£¬°üÀ¨Õë¶Ô¸ß¼¶ÐèÇ󹿻®µÄOracle Demantra¡¢Oracle Agile²úÆ·ÐÔÃüÖÜÆÚÖÎÀí½â¾ö·½°¸¡¢Oracle Siebel CRMºÍ Oracle ÔËÔØÖÎÀí¡£
ÏÖ½ñ£¬Õë¶ÔOracleµç×ÓÉÌÎñÌ×¼þµÄOracleÆóÒµ¼ÓËÙÆ÷£¬ÔÚ20¸ö¹ú¼Ò8¸öÐÐÒµÖÐÔË×÷Solaris Ê®²Ù×÷ϵͳµÄSun 64-bitϵͳÉÏÊ©Ó㬺ϼÆÓг¬¹ý280¸öOracleÆóÒµ¼ÓËÙÆ÷ÔÚ35¸ö¹ú¼ÒÔËÓá£
ÏÖ½×¶ÎOracle¼Ó¿ì¼Æ»®¿ÉÌṩ¶àÖÖµ÷¶ÈÈ¡Éᣬ°üÀ¨OracleÍйܡ¢µÚÈý·½ÍйÜÒÔ¼°ÄÚ²¿µ÷¶ÈÐÍÍйܣ¬ËùÓÐÕâЩµ÷¶È¶¼Ìṩ¶¨×ö»¯µÄ·þÎñ°üÀ´Âú×ãÿ¸ö¿Í»§µÄ¶ÀÌØÐèÇó¡£
ÔÚеÄOracle¼Ó¿ì¼Æ»®ÃŵÚ-- midsize.oracle.comÖУ¬°üÔÐÓÐÒ»¸öºÏ×÷»ï°éÊг¡£¨Partner Marketplace£©°æ¿é£¬ËüÄÜÏàÖú¿Í»§ºÜ¼òÂÔÕÒ³öOracleÓ¦ÓÃÈí¼þºÍOracle¼Ó½ô¼Æ»®½â¾ö·½°¸µÄ׼ȷ½áºÏ¡£
±¾ÎÄÀ´Ô´£º
ÎÒµÄÒì³£Íø
Java Exception
Dotnet Exception
Oracle Exception
Ïà¹ØÎĵµ£º
ͨ³£ÎÒ們ÔÚ½¨Á¢ PostgreSQL/Oracle 資ÁÏ庫µÄ時ºò, Èç¹ûҪʹÓà MySQL/MS-SQL identity À×ͬµÄ¹¦ÄÜ, ¾ÍÊÇÒª採Óà Sequence 來½¨Á¢, ¶ø為ÁËÿһ個 Table ¶¼ÓÐ獨Á¢µÄÐò號產ÉúÆ÷, ÎÒ們會½¨Á¢個別µÄ sequence.
ÀýÈç (PostgreSQL samp ......
ǰÕó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......
ORACLEÖ÷ÒªÓÉÁ½²¿·Ö×é³É£ºInstanceºÍDatabase¡£InstanceÊÇÖ¸Ò»×éºǫ́½ø³Ì/Ï̺߳ÍÒ»¿é¹²ÏíÄÚ´æÇøÓò£¬¶øDatabaseÊÇÖ¸´æ´¢ÔÚ´ÅÅÌÉϵÄÒ»×éÎïÀíÎļþ¡£
ORACLEÊý¾Ý¿âµÄÆô¶¯Ö÷Òª·Ö3¸ö²½Ö裺
1¡¢Æô¶¯µ½nomount״̬£»
2¡¢Æô¶¯µ½mount״̬£»
3¡¢Æô¶¯µ½open״̬¡£
ÏÂÃæ·ÖÎöÒ»ÏÂÆô¶¯µÄ¸÷¸ö²½Ö裺
Ò»¡¢Æô¶¯µ½nomount״̬
......
ËäÈ»ÍøÉÏÓкܶ࣬µ«»¹ÊÇÔÚÕâÀï¼ÇÏ·½±ã²éÕÒ£º
SELECT i.ksppinm NAME, i.ksppity TYPE, v.ksppstvl VALUE, v.ksppstdf isdefault
from x$ksppi i, x$ksppcv v
WHERE i.indx = v.indx
AND i.ksppinm LIKE '\_%&par%' ESCAPE '\';
......