C# ÏòoracleÊý¾Ý¿â²åÈë¸üеÄËÙ¶ÈÎÊÌâ
Ïò´ó¼ÒÇë½ÌÒ»¸öÎÊÌâ
C# ÏòoracleÊý¾Ý¿â²åÈ룬ÈçºÎÄÜÈ¥Ìá¸ßЧÂÊ£¿£¿£¿
ÎÒÏÖÔÚ²åÈëÊý¾Ý¿âµÄÊÇÿ5Ãë²åÈëºÍ¸üУ¬Ã¿´Î²åÈëºÍ¸üеÄÊýÄ¿´ó¸ÅÓÐ300Ìõ¼Ç¼×óÓÒ£¡£¡²¢ÇÒÊÇÓöàÏß³Ìͬʱȥ²åÈëºÍ¸üÐÂ
OracleµÄÈÕÖ¾»á²»»áÀÛ»ýÏÂÀ´£¬¶ø»áµ¼Ö²åÈëµÄЧÂʵģ¿
OracleÊDz»ÊÇÓÐÒ»¸ö²¢ÐвåÈëºÍ¸üÐµģ¿£¿£¿ÓеÄÄÇÓ¦¸ÃÔõÑùÈ¥ÉèÖã¿£¿£¿
alter table tablename nologging£»
û°ì·¨C#»ùÓÚ.Net²»»á¿ìµÄ¡£
ÊDz»ÊÇÿһ¸ö±í½¨Á¢µÄʱºò¶¼Òª¼ÓÕâ¾ä£¿£¿
¸ù¾ÝÐèҪʹÓÃ
ÎÒ²»Ì«Ã÷°×°¡~~~~
²åÈëºÍ¸üУ¬ÎÒ¶¼ÊÇÓô洢¹ý³ÌÿһÌõÈ¥²åÈë»ò¸üеÄ
ÅóÓÑ£¬ÄãÓоßÌåµÄÀý×ÓÂ𣿣¿£¿£¿
ʱ¼ä³¤ÁË£¬¼Ç¼¶àÁË£¬¿Ï¶¨»á³öÏÖÓ°ÏìËٶȵÄÎÊÌ⣬ЧÂÊÎÊÌâÒª¿¼ÂǵÄÒòËØºÜ¶à£¬³¤ÆÚÀ´¿´³ÌÐòÓ°ÏìµÄÒòËØÒѾºÜСÁË£¬Òª´ÓÊý¾Ý¿â±¾ÉíÀ´ÓÅ»¯µÄ¡£ÒªÔ¤ÆÚһϽ«À´Êý¾ÝÒªÓжà´ó£¬ÄÜ·ñ¶¨ÆÚ±¸·Ý²»³£ÓõÄÊý¾Ý²¢´Óµ±Ç°¿âÖÐɾ³ý£¬»¹ÓÐÓ²¼þµÄÅäÖÃÒ»¶¨Òª¾¡Á¿µÄ¸ßÅäÖÃһЩ¡£
¶¥
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......