ASP.NETÅäÖÃOracleµÄÏà¹ØËµÃ÷
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² Oracle9i°²×°³É¹¦ÒԺ󣬾ßÌåµÄȨÏÞÉèÖÃÈçÏ£º
1. ÒÔAdministratorȨÏ޵ǼWindows.
2. Æô¶¯Window ×ÊÔ´ä¯ÀÀÆ÷ÕÒµ½ORACLE_HOMEĿ¼£¬ÈçC:\Oracle\ora92
3. ÓÒ¼üµ¯³ö²Ëµ¥£¬Ñ¡Ôñ¸ÃĿ¼¹²ÏíÓ밲ȫ£¨Win2000ÏÂÒªµã»÷ÊôÐÔ£©
4. µã»÷ “°²È«” ҳǩ
5. ÔÚ×éºÍÓû§Ãû³ÆÁбíÖеã»÷“Authenticated Users” Ïî.
6. ÔÚ¸ÃÓû§µÄȨÏÞÁбíÖУ¬½«“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿òÖÃΪ²»Ñ¡ÖÐ״̬
7. Ôٴεã»÷“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿ò£¬½«ÆäÉèÖÃΪѡÖÐ״̬
8. µã»÷“¸ß¼¶”°´Å¥²¢ÔÚȨÏÞÏîÄ¿ÖÐÈ·¶¨“Authenticated Users” ÊÇ·ñÓµÓГ¶ÁÈ¡²¢ÔËÐДȨÏÞ²¢Ó¦ÓÃÓÚ“¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. Èç¹û²»ÊÇ£¬Ë«»÷ÕâÑù£¬²¢È·±£È¨ÏÞ¿ÉÒÔ“Ó¦ÓÃÓÚ” “¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. ¸ÃÏî·Ç³£ÖØÒªÄãÒ»¶¨ÒªºË²é.
9. µã»÷“È·¶¨” °´Å¥
10. Windows.ÖØÆô¶¯, ÒÔʹµÃËùÓеÄÐÞ¸ÄÉúЧ.
Ïà¹ØÎĵµ£º
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃæ¹¤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”&mdash ......
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌØµã£º¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶øÂ ......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......
1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......