"ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾"½â¾ö°ì·¨
1.Ñ¡ÔñÄúËù°²×°OrcaleµÄĿ¼£¬ÀýÈ磺C:\Oracle
2.ÓÒ¼üµã»÷£¬µ¯³ö“ÊôÐÔ”¶Ô»°¿ò£¬Ñ¡Ôñ“°²È«”Ñ¡Ï
3.Ìí¼Ó“IUser_»ú×ÓÃû³Æ”Óû§µÄȨÏÞ£¬²ÉÓÃÍêÈ«¿ØÖƵķ½Ê½
4.È·¶¨Ó¦Óúó£¬ÔÚÑ¡Ôñ“°²È«”Ñ¡ÏÖÐÑ¡Ôñ“IUser_»ú×ÓÃû³Æ”Óû§£¬µã»÷¸ß¼¶
5.Ñ¡ÔñÑ¡Ôñ¿ò“ÓÃÔÚ´ËÐÄʵĿÉÒÔÓ¦Óõ½×Ó¶ÔÏóµÄÏîÄ¿´úÌæËùÓÐ×Ó¶ÔÏóµÄȨÏÞÏîÄ¿(P)”
6.µã»÷Ó¦Ó×—È·¶¨¼´¿É¡£
Ôø¾³¢ÊÔ¹ýÔÚ°²×°Ä¿Â¼ÉèÖÃNETWORK SERVICEÓû§µÄȨÏÞ£¬¿ÉÄÜÉÙÁË3ºóµÄ²½Ö裬ËùÒÔûÓгɹ¦£¡´ó¼Ò¿ÉÒÔÊÔÊÔ£¬Ó¦¸ÃÊÇ¿ÉÒԵġ£
´Ë²Ù×÷Ö÷ÒªÊÇΪÁËÈÃÄúµÄÓ¦ÓóÌÐò¿ÉÒÔ·ÃÎÊORCALE°²×°Ä¿Â¼Ïµēsqlnet.ora”Îļþ£¬ÆäÖмǼÁËÊý¾Ý¿â·þÎñµÄÁ¬½ÓµØÖ·¡£
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/mdmzl/archive/2009/06/15/4269835.aspx
Ïà¹ØÎĵµ£º
Oracleѧϰ±Ê¼ÇһʵÀý
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
ÔÚSql ......
Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......
oracle 10.2.0.4 patchµÄÏÂÔØµØÖ·Áбí
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://d ......
±¾Îijö×Ô “inthirties£¨ÄÐÈËÈýÊ®£©”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦£¬Î´¾×÷ÕßÐí¿É×ªÔØ£¬±Ø×·¾¿·¨ÂÉÔðÈΡ£
ÔÚIBM AIXÉϰ²×°Oracle RAC (RS/6000)
Ä¿µÄ
´ËÎĵµÏò¶ÁÕßÌṩÈçºÎ°²×°Ò»¸öȺ¼¯£¬°²×°RAC£¬²¢ÔÚIBM AIX HACMP/ES (CRM) 4.4.xÉÏÆô¶¯Ò»¸öȺ¼¯Êý¾Ý¿âµÄÊÖ°ÑÊÖÖ¸µ¼Êֲᣬ¶ÔÓÚ¹ØÓÚÈκÎÕâЩ²½ÖèµÄÆäËü½ ......
1.ÊÓͼ£¨VIEW£©
1.1 ¸ÅÄî
ÊÓͼ-----ÊÇÓÉSELECT²éѯÓï¾ä(¿ÉÒÔÊǵ¥±í»òÕß¶à±í²éѯ)¶¨ÒåµÄÒ»¸ö"Âß¼±í",Ö»Óж¨Òå¶øÎÞÊý¾Ý,ÊÇÒ»¸ö"Ðé±í". ÔÚ´´½¨ÊÓͼʱ,Ö»Êǽ«ÊÓͼµÄ¶¨ÒåÐÅÏ¢±£´æÔÚÊý¾Ý×ÖµäÖÐ, ¶ø²¢²»½«Êµ¼ÊµÄÊý¾Ý¸´ÖƵ½Èκεط½, ¼´²»ÐèÒªÔÚ±í¿Õ¼äÖÐΪÊÓͼ·ÖÅä´æ´¢¿Õ¼ä. ÊÓͼÊDz鿴º ......