oracleÇ¨ÒÆ - Oracle / »ù´¡ºÍ¹ÜÀí
oracle°æ±¾ÊÇ10.2 .0.1.0ÏȰÑÒÔǰµÄÄǸö¿ª·¢·þÎñÆ÷½øÐÐÉý¼¶¡£»»¸öеķþÎñÆ÷¡£ÏÖÔÚÊý¾Ý¿âÀïÃæµÄÊý¾ÝÔõÃ´Ç¨ÒÆµ½Ð·þÎñÆ÷¡£Ï£ÍûÓÐÕâ·½ÃæµÄ×ÊÁÏ»ò¸øÐ©Ìáʾ¡£Ð»Ð»´ó¼Ò¡£
²»¶®....·¹ý . ÔÚеķþÎñÆ÷Éϰ²×°ºÃÊý¾Ý¿â£¬½¨ºÃÏà¹ØÓû§ºÍ±í¿Õ¼ä£¬ÊÇоÉÊý¾Ý¿âµÄ±í¿Õ¼äÒ»Ö Èç¹û²»½¨Á¢µÄ»°,ÊDz»ÊǶ¼µ¼µ½systemÏÂÁË? expdp/impdp -- Èç¹ûÁ½·þÎñÆ÷µÄ°æ±¾Ïàͬ(²Ù×÷ϵͳλÊýÏàͬ£º¶¼ÊÇ32λ»òÕß64λ) -- ÇÒSIDÒ²Ò»ÑùµÄ»° -- ¹Ø±ÕÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â) £ºÖ±½Ócopy ËùÓеÄÊý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢³õʼ»¯²ÎÊýÎļþµ½ÆäÏàÓ¦µÄλÖü´¿É! -- Èç¹ûÁ½·þÎñÆ÷µÄ²Ù×÷ϵͳ°æ±¾Ïàͬ(²Ù×÷ϵͳλÊýÏàͬ£º¶¼ÊÇ32λ»òÕß64λ) -- ÇÒSIDÒ²Ò»ÑùµÄ»° -- ¹Ø±ÕÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â) £ºÖ±½Ócopy ËùÓеÄÊý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢³õʼ»¯²ÎÊýÎļþµ½ÆäÏàÓ¦µÄλÖü´¿É! -- Èç¹ûÁ½·þÎñÆ÷µÄ°æ±¾Ïàͬ(²Ù×÷ϵͳλÊýÏàͬ£º¶¼ÊÇ32λ»òÕß64λ) -- ÇÒSIDÒ»Ñù£¬ÇÒÊý¾Ý¿âµÄ°²×°Â·¾¶Ò²Ò»ÑùµÄ»° -- ¹Ø±ÕÊý¾Ý¿â(Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿â) £ºÖ±½Ócopy ËùÓеÄÊý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢³õʼ»¯²ÎÊýÎļþµ½ÆäÏàÓ¦µÄλÖü´¿É!ÒýÓà ¿ÉÒÔʹÓà exp/imp »òÕß expdp/impdp 1. ÏȽ«Êý¾Ý¿âµ¼³ö 2. ÔÚеķþÎñÆ÷Éϰ²×°ºÃÊý¾Ý¿â£¬½¨ºÃÏà¹ØÓû§ºÍ±í¿Õ¼ä£¬ÊÇоÉÊý¾Ý¿âµÄ±í¿Õ¼äÒ»Ö 3. ½«Êý¾Ýimp 4. ¼ì²éÓÐÎÞÎÞЧ¶ÔÏó£¬ÓоͱàÒëһϣ¬Ã»ÓоÍokÁË¡£ ²Î¿¼£º ORACLE Êý¾Ý¿âÂß¼±¸·Ý ¼òµ¥ EXP/IMP http://blog.csdn.net/tianlesoftware/arch¡¡ ÕýºÃÒªÓã¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
oracleº¯ÊýÈçÏ£º create or replace function P_WEB_GETCITYID ( p_mobileNumber in VARCHAR2, p_cityid out NUMBER ) Return NUMBER IS p_areacode varc ......
ÎÒÓÃmyeclipseÁ¬½ÓOracleÒ»Ö±±¨´í£¬Ò»ÏÂÊDZ¨´í½ØÍ¼£¬ Çó¸ßÈËÏàÖú¡£ ÎÞͼÎÞÕæÏà.... file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png .... Äã¿´¿´Çý¶¯ºÍORACLEµÄ°æ ......