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

OracleÓû§±í¿Õ¼ä±¦µä

Oracle»¹ÊDZȽϳ£Óõģ¬ÓÚÊÇÎÒÑо¿ÁËÒ»ÏÂOracleÓû§±í¿Õ¼ä£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£ÔÚÎÒÃÇΪ΢ÈíµÄNTFS·ÖÇø¸ñʽÖеÄÓû§´ÅÅÌÅä¶î¹ÄÕƵÄʱºò£¬OracleÊý¾Ý¿âÖÐÒ²ÒѾ­ÊµÏÖÁËÓû§´ÅÅÌÅä¶îµÄ¼¼Êõ¡£¿ÉÒÔ½èÖú±í¿Õ¼ä£¬À´¶ÔÓû§½øÐдÅÅÌÅä¶î¹ÜÀí¡£ÀûÓñí¿Õ¼äµÄÓû§´ÅÅÌÅä¶î£¬¿ÉÒÔʵÏֺܶ๦ÄÜ¡£
Èç¿ÉÒÔÀûÓÃÓû§´ÅÅÌÅä¶î£¬À´¹ÜÀíÓû§´´½¨Êý¾Ý¿â¶ÔÏóµÄÄÜÁ¦¡£ÎÒÃǶ¼ÖªµÀ£¬ÈôÓû§ÏëÒªÔÚij¸ö±í¿Õ¼äÖд´½¨·½°¸¶ÔÏóµÄ»°£¬±ØÐëͬʱÂú×ãÁ½¸ö¶ÔÏó¡£Ò»ÊÇÓû§¾ßÓÐÊý¾Ý¿âϵͳÖÐCREATE TABLEµÈÏà¹ØµÄȨÏÞ;¶þÊÇÔÚÕâ¸ö·½°¸¶ÔÏóʹÓõıí¿Õ¼äÖоßÓÐÅä¶î¡£ÒòΪÕâÁ½¸öÌõ¼þ±ØÐëͬʱÂú×㣬Óû§²ÅÄܹ»³É¹¦µÄ½¨Á¢¶ÔÏó¡£ËùÒÔ£¬ÈôÎÒÃÇ¿ÉÒÔ²»¸øÓû§Ä³¸ö±í¿Õ¼äµÄÅä¶î£¬Èç´ËµÄ»°£¬¾Í¿ÉÒÔÏÞÖÆÓû§µÄÏà¹Ø²Ù×÷¡£
ÁíÍ⣬ÎÒÃÇÒ²¿ÉÒÔÀûÓôÅÅÌÅä¶îÀ´¶ÔÓû§½øÐÐÊý¾Ý´óСµÄÏÞÖÆ¡£ÒòΪÓÐʱºòÎÒÃÇ¿ÉÄÜÔÚͬһ̨Êý¾ÝÆ÷ÖØ»áÔËÐжà¸öÓ¦Ó÷þÎñ¡£Èç±ÊÕßÒÔÇ°ÔÚͬһ̨·þÎñÆ÷ÀïͬʱÔËÐÐÓÊÏäÓëOracleÊý¾Ý¿âϵͳ¡£ÎªÁËÈüõÉÙÕâ¸öÁ½¸öϵͳ¶ÔÓ²ÅÌ¿Õ¼äµÄ¹ý¶ÉÓ¦Óã¬ËùÒÔ£¬ÓбØÒª¶ÔËûÃǽøÐдÅÅÌÅä¶îµÄÏÞ¶¨¡£¹Ê£¬ÈçÓÃÊý¾Ý¿â¹ÜÀíÔ±ÐèÒª½«×ÊÔ´ÏÞÖÆ×÷Ϊ×Ô¼ºÊý¾Ý¿â°²È«²ßÂÔµÄÒ»²¿·ÖµÄ»°£¬¾Í¿ÉÒÔ¿¼ÂÇΪÿ¸öÓû§ÉèÖñí¿Õ¼äÅä¶î¡£
×ÜÖ®£¬±ÊÕßÈÏΪ£¬±í¿Õ¼äÅä¶îÊÇÒ»¸öºÜ²»´íµÄ¸¨Öú¹ÜÀí¹¤¾ß¡£±ÊÕßÔÚÕâ·½Ãæ¹ÜÀíÉÏ£¬ÉÔÓÐÐĵ㬸úÓÐʶ֮ʿ£¬ÌÖÂÛÌÖÂÛ¡£
Ò»¡¢¸øÓû§·ÖÅä±í¿Õ¼ä¡£
ÔÚOracleÊý¾Ý¿âÖУ¬¶ÔÓÚÓû§µÄ´ÅÅÌÅä¶îÊÇͨ¹ý±í¿Õ¼äÀ´ÊµÏֵġ£¸øij¸öÓû§·ÖÅäÁ˶àÉٵıí¿Õ¼ä£¬Õâ¸öÓû§¾ÍÓжàÉٵĴÅÅÌÅä¶î¡£ËùÒÔ£¬¶ÔÓÚÓû§½øÐдÅÅÌÅä¶îµÄ¹ÜÀí£¬¾ÍÊǶÔÓû§½øÐбí¿Õ¼äµÄÏÞÖÆ¡£
ÔÚ´´½¨Óû§µÄʱºò£¬ÈôûÓйØÁª±í¿Õ¼ä£¬ÔòÆäÒ»°ãÇé¿öÏ£¬¾ÍÊôÓÚĬÈϵıí¿Õ¼ä¡£¶øÆäÓµÓбí¿Õ¼äµÄ´óС£¬ÔòÊǸù¾ÝÆäËùÊô½ÇÉ«µÄ²»Í¬¶øÓÐËùÇø±ð¡£ÈçÆäÊôÓÚresource×éµÄ»°£¬ÔòÆä±í¿Õ¼äÊÇûÓдóСÏÞÖƵġ£
Ò»°ãÇé¿öÏ£¬ÈôÊý¾Ý¿â¹ÜÀíÔ±ÐèÒª¶Ô±í¿Õ¼ä½øÐдÅÅÌÅä¶î¹ÜÀíµÄ»°£¬Ôò±ÊÕß½¨Ò飬ÔÚÓû§½¨Á¢µÄʱºò£¬ÎªÓû§Ö¸¶¨±í¿Õ¼ä£¬²¢ÉèÖñí¿Õ¼äµÄ´óС¡£ÈçÎÒÃÇ¿ÉÒÔÀûÓÃÈçÏÂÕâÌõÃüÁîÅäÖÃÓû§µÄ´ÅÅÌ¿Õ¼äÅä¶î£ºALTER USER user_name QUOTA ** ON tablespace¡£ÆäÖвÎÊýUser_name±íʾÓû§Ãû£¬¶ø²ÎÊýTablespace±íʾÓû§ËùÊôµÄ±í¿Õ¼ä¡£ÈôÎÒÃDzÎÊýÉèÖÃΪUNLIMITEDµÄ»°£¬±íʾÕâ¸öOracleÓû§±í¿Õ¼äûÓÐÏÞÖÆ£¬Ö±µ½ËùÓеĿռäÓÃÍêΪֹ¡£
ËùÒÔ£¬ÔÚÒ»°ãÇé¿öÏ£¬Á½ÖÖÇéÐÎϵÄÓû§¾ßÓÐÎÞÏÞÖƵĴÅÅÌÅä¶î¡£Ò»ÊÇÕâ¸öÓû§ÊôÓÚresourceÕâ¸ö½ÇÉ«£¬ÒòΪÕâ¸ö½ÇɫĬÈÏÇé¿öÏ£¬ÆäÊÇ


Ïà¹ØÎĵµ£º

ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿


ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿ 
 
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨Ô­ÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2  Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......

oracleÖÐDateÀàÐÍ×Ö¶ÎÊý¾Ý²åÈë¸ñʽ

   oracle±íÖÐÓÐDateÀàÐ͵Ä×ֶΣ¬ÓÃPD×Ô¶¯Éú³É²âÊÔÊý¾Ý£¬¸ñʽΪ‘yyyy-mm-dd’£¬¶øoracleÖвåÈëDateÀàÐ͵Ä×ֶθñʽΪ'dd-mmÔÂ-yyyy'¡£Èç¹ûÊý¾ÝÁ¿ÉÙ£¬¿ÉÒÔÓÃto_date()£¬
to_date('2008-01-25 12:39:49','YYYY-MM-DD HH24:MI:SS')
µ«ÊDzâÊÔÓÃÊý¾ÝÓÐ10ÍòÌõ£¬Èç¹ûÊܶ¯È¥Ð´ÏÔÈ»ÊDz»Êµ¼ÊµÄ¡ ......

ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ


ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ 
 
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅҪΠ......

ͨ¹ý´´½¨ÐòÁÐÀ´ÊµÏÖORACLE SEQUENCEµÄ¼òµ¥½éÉÜ

ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢Create Sequence
ÄãÊ×ÏÈÒªÓÐCREATE SEQUENCE»òÕßCREATE ANY SEQUENCEȨÏÞ£¬
CREATE SEQUENCE emp_sequence
INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
NOCY ......

ORACLE nulls first or nulls lastÓ﷨ѧϰ

ʹÓÃnulls first »òÕßnulls last Óï·¨
 
Nulls firstºÍnulls lastÊÇOracle Order byÖ§³ÖµÄÓï·¨
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls firstÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îÇ°(²»¹ÜÊÇasc »¹ÊÇ desc)
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls lastÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îºó (²»¹ÜÊÇasc »¹ÊÇ desc)
ʹÓÃÓï·¨ÈçÏ£º
--½«nulls ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ