Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Íêȫɾ³ýOracle


ʵÏÖ·½·¨£º
     1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
     2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
     3¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
     4¡¢ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú¡£
     5¡¢ÔËÐÐregedit£¬
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application£¬
ɾ³ýËùÓÐOracleÈë¿Ú¡£
     6¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾ÏµÍ³£­£¾¸ß¼¶£­£¾»·¾³±äÁ¿
ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
     7¡¢´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
     8¡¢É¾³ý\Program Files\OracleĿ¼
     9¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
     10¡¢É¾³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë
¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓWindows 2000Ŀ¼£¨Ò»°ãΪC:\WINNT£©ÏÂɾ³ýÒÔÏÂÎÄ
¼þORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ¡£
     11¡¢ WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î£¬É¾³ý¸Ã¶Î
     12¡¢ ÈçÓбØÒª£¬É¾³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN
     13¡¢ µ½Ê¼þ²é¿´Æ÷ÖУ¬É¾³ýOracleÏà¹ØµÄÈÕÖ¾
     ˵Ã÷£º
     µ½ÏÖÔÚΪֹ£¬Ä㻹ÊÇ¿ÉÒÔ·¢ÏÖÔÚ·þÎñÀïÃæ»¹ÓÐoracleµÄ·þÎñ´æÔÚ£¬±ØÐë°ÑËûɾ³ý£¬·ñÔòÄãÔÙ°²×°oracleʱ¾Í»á³öÏÖʲô·þÎñÒѾ­´æÔڵĴíÎóÌáʾÁË£¡£¡¶øÕâЩ·þÎñÊÇÔÚHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\RootÏÂÒÔLEGACY_ORACLE´òÍ·µÄ£¬¶øÇÒÄãÑ¡ÖÖ°´deleteɾ³ýʱϵͳ»áÌáʾÄãÒ»¸ö´íÎ󣡣¡²»ÈÃÄãɾ³ý£¡£¡£¡ÏÖÌṩ¾ßÌåɾ³ý·½·¨£¬
win2000µÄÈçÏ£º
     ÔËÐÐregedt32×¢ÒâÁË£¬²»ÊÇregedit£¡£¡£¡£¡ÔÚHKEY_LOCAL_MACHINEÄÇÒ³ÕÒµ½HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\E


Ïà¹ØÎĵµ£º

¹ØÓÚoracleÊý¾Ý¿â°²×°²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿âµÈÎÊÌâ


³õ³õѧϰoracle 10g,×î»ù±¾µÄÎÊÌâ¾ÍÊǰ²×°Êý¾Ý¿â,³õ³õ°²×°Êý¾Ý¿âʱ,°²×°Óë±ðÈ˵ͼ²î²»¶à,¾ÍÊÇÔÚ×îºóʱ,²»ÄÜ×ÔÐÐÅä×°Êý¾Ý¿â,Òª×Ô¼ºÅäÖÃÊý¾Ý¿â,×îºó¾­¹ý×Ô¼ºµÄÅŲé:ÔÚ°²×°ÏµÍ³Ê±,ϵͳµÄ¼ÆËã»úÃû³Æ(×¢²á¼ÆËã»úʱÓõÄ)ΪӢÎÄ,Óû§Ãû³ÆÎªÖÐÎÄ,Òò´Ë²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿â,
¾­¹ý±¾È˵Ķà´ÎʵÑé,ÔÚ¼ÆËã»úÃû³Æ¡¢Óû§ÃûΪӢÎĵÄ×´Ì¬Ï ......

ORACLE NULLÏê½â

ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ­¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵Ã÷£º
1¡¢µÈ¼ÛÓÚûÓÐÈκÎÖµ¡¢ÊÇδ֪Êý¡£
2 ......

¹ØÓÚOracleµÄÐòÁУ¨Sequence£©Ê¹ÓÃ

OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......

ÉîÈëѧϰOracle·ÖÇø±í¼°·ÖÇøË÷Òý

http://www.csip.com.cn/88/n-52488.html
 ¹ØÓÚ·ÖÇø±íºÍ·ÖÇøË÷Òý(About Partitioned Tables and Indexes)¶ÔÓÚ10gR2¶øÑÔ£¬»ù±¾ÉÏ¿ÉÒԷֳɼ¸Àࣺ
Range(·¶Î§)·ÖÇø
Hash(¹þÏ£)·ÖÇø
List(Áбí)·ÖÇø
ÒÔ¼°×éºÏ·ÖÇø£ºRange-Hash,Range-List¡£
¶ÔÓÚ±í¶øÑÔ(³£¹æÒâÒåÉϵĶÑ×éÖ¯±í)£¬ÉÏÊö·ÖÇøÐÎʽ¶¼¿ÉÒÔÓ¦ÓÃ(ÉõÖÁ¿ÉÒÔ¶Ôij¸ö ......

OracleÊý¾Ý¿â·ÖÇø±í²Ù×÷·½·¨

http://www.diybl.com/course/7_databases/oracle/oraclejs/2007614/52942.html
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓᣠ
¡¡¡¡ ÔÚ´óÐÍµÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½T ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ