¹â»·¾¡Ê§ OracleÔÚÖйúÈ«ÃæÔâÓö¡°»¬Ìú¬¡±
¼Ì9Ô·ݹúÄÚijÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ»Õó¡£
ÑÛ¿´×ÅÀë2009ÄêÄêÖÕÒÑûÓм¸Ì죬¹ØÓÚOracleµÄ¸÷Öַ粨ҲËƺõ½¥½¥Æ½Ï¢£¬ÕûÈÕæÓÚËÄ´¦¾È»ðµÄOracleÖйú¹«Ë¾µÄÊг¡Ó빫¹ØÈËÔ±£¬»òÐíÕý×¼±¸°ÑÐÄ·ÅÏ¡¢ºÃºÃÐÝÏ¢¼¸Ì죬ÒÔ±¸Ã÷Äê“ÖØÕûɽºÓ”¡£¶ø¾ÍÔÚ´Ëʱ£¬12ÔÂ14ÈÕ£¬Öйú×îÓÐÓ°ÏìµÄרҵITýÌå——¡¶Öйú¼ÆËã»ú±¨¡·ÓÖÒÔһƪÑóÑóÒ»Íò¶àÑԵķâÃæ´ó¸å——¡¶¼×¹ÇÎÄÖйúÂÒÏó¡·£¬´Ó°¸Àý¡¢²úÆ·¡¢ÇþµÀ¡¢·þÎñ¡¢±¾ÍÁ»¯¡¢°²È«ÎÊÌâµÈÖî¶à·½Ã棬ȫÃæ¡¢³¹µ×µØ½Ò¿ªÁ˼׹ÇÎÄÔÚÖйúµÄÉñÃØÃæÉ´£¬ÁîÆä¹â»·¾¡Ê§——ÓÉ´Ë¿É¿´³ö£¬OracleÔÚÖйúÒÑÈ«ÃæÔâÓö“»¬Ìú¬”¡£
ÕýÈç¸ÃÆڵġ¶Öйú¼ÆËã»ú±¨¡·µÄ·âÃæÕªÒªËù˵£¬Oracle ÔÚÖйú“¿Í»§ÊýÁ¿Öڶ౳ºóµÄÕæʵÇé¿öÊÇ£¬ºÜ¶àCIOÃæ¶ÔÇ¿ÊƼ׹ÇÎÄÓпàÄÑÑÔ£ºÊÛºó·þÎñ·ÑÓøߡ¢²»ÄÜÌṩÏÖ³¡·þÎñ¡¢²úÆ·²»¹»±¾µØ»¯¡¢Õë¶Ô¹úÄÚÐèÇóÎÞÈκÎÖ§³Ö……±íÃæ¹âÏʸ¡»ªµÄ¼×¹ÇÎÄ£¬ÔÚÖйúÆäʵÒÑÈ»ÂÒÏó´ÔÉú¡£”
ÎÄÕÂÒÔÏêʵµÄ°¸ÀýÓëÊý¾Ý£¬Ò»Ò»ÁоÙÁËOracleÔÚÖйúÖî¶à²»ÎªÈËÖªµÄʧ°Ü°¸Àý£¬ÓÈÆäÊÇOracleÊÓΪ×îÖØÒªÒ²×ÔÊÓ×î³É¹¦µÄ½ðÈÚÐÐÒµ£¬¼ÇÕßͨ¹ý¶à·½Î»µ÷²é£¬¾º“ÍÚ”³öÁË°üÀ¨ÖйúÒøÐÐÔÚÄÚµÄ10¼ÒÒøÐкÍ1¼Ò֤ȯ¹«Ë¾µÄOracle ERPϵͳʵʩÓëÓ¦ÓõÄÖî¶à²»³É¹¦Ö®´¦——ËäÈ»¼ÇÕßûÓÐÖ±½Ó˵Ã÷ÕâЩ°¸ÀýÍêȫʧ°Ü£¬µ«´Ó¼ÇÕßËùÒýÊöµÄ¹úÄÚÍâ¶ÔÓÚERPʧ°ÜµÄ½ç¶¨±ê×¼À´¿´£¬ÕâЩ°¸ÀýÏÔÈ»ÊÇʧ°ÜµÄ——³¬Ô¤Ëã¡¢³¬Ê±¼ä¡¢Î´ÄÜ´ïµ½Óû§ÊµÊ©Ô¤ÆÚ£¬Î´ÄÜÓÐЧµØʹÓÃIT¼¼Êõ¼¯³ÉÈ«²¿ÒµÎñÁ÷³Ì£¬Ã»ÓÐÄõ½Óû§µÄÏîĿʵʩ³É¹¦ÑéÊÕ±¨¸æ……
¶ø³ý´ËÖ®Í⣬¼ÇÕß»¹ÒýÊöÁ˹úÄÚ×î´óµÄijIT¼¼ÊõÉçÇøÖÐÍøÓÑÁоٵİüÀ¨±±¾©¶àÔªµçÆ÷¡¢Öк£ÓÍ¡¢Èý½ÇÂÖÌ¥¡¢´óÁ¬ÊµµÂ¡¢¹þÒ©¼¯ÍÅ¡¢É³¸ÖµÈÔÚÄÚµÄÖî¶àOracleÔÚÖйúµÄÔø¾µÄʧ°Ü°¸Àý¡£
Èç´ËÖ®¶àµÄ²»³É¹¦°¸Àý£¬»òÐíÕýÈçÎÄÖÐËù˵µÄ“±ùɽһ½Ç”£¬ÓÉÓÚÎÄÕÂÖÐËù˵µÄÓû§¸÷ÖÖ²»Ô¸Òâ³ÐÈÏERPÏîĿʵʩʧ°ÜµÄÔÒò£¬Oracle Õâ¸öºÅ³Æ“È«Çò×î´óµÄÆóÒµÈí¼þ¹«Ë¾”ºÍ“ÊÀ½çµÚ¶þ´ó¹ÜÀíÈí¼þ¹©Ó¦ÉÌ”£¬ÔÚÆäÖй
Ïà¹ØÎĵµ£º
delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷ ......
»¹ÊǼ¸Î»¶ÁÎÒµÄÊé (¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX UNIXÉϵÄʵսÏê½â¡·) µÄ¶ÁÕßÀ´Óʼþ×ÉѯÎÊÌ⣬ºÜ±§Ç¸ÎÒ²»ÄÜÖðλ»Ø¸´Óʼþ£¬µÚÒ»ÎÒÕæµÄͦ棬µÚ¶þÕâЩÎÊÌâÆÄÓй²ÐÔ¡£ÎÒÀ´½èÖúÕâ¸öµØ·½£¬Í³Ò»µØºÍÖîλ̽ÌÖ£¬ºÜ¶àÎÊÌâÎÒÒ²ÊÇÔÚÃþË÷ÖУ¬²»ÄÜÖ±½Ó¸ø´ó¼Ò´ð°¸£¬ºÇºÇ£¬´ó¼Ò¼ûÁ°¡!
˵˵ËøÎÊÌâ¡£ MS SQLÖ§³ÖµÄËøÀàÐͺÍOracle²îÒìÊǺ ......
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\\ORACLE
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££ ......
Close a Database
When you close a database, Oracle writes all database data and recovery data in the SGA to the datafiles and redo log files, respectively. Next, Oracle closes all online datafiles and redo log files. (Any offline datafiles of any offline tablespaces have been closed already. If you ......