Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âDBFÎļþÎóɾ³ý½â¾ö·½°¸

·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......

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


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

ORACLEÊý¾Ý¿âÄÚ´æ²ÎÊýÉè´óÓÚ8GµÄÄÚ´æÆô¶¯³ö´íÎÊÌâ½â¾ö


ORACLEÊý¾Ý¿âÄÚ´æ²ÎÊýÉè´óÓÚ8GµÄÄÚ´æÆô¶¯³ö´íÎÊÌâ½â¾ö 
 
4¸öINTEL 1.6g 4ºËCPU£¬16G Äڴ棬°²×°ÍêORACLE 10G FOR RED HAT LINUX£­64UPDATA4X86-64  ×¼±¸µ¼Êý¾Ý½øÈ¥£¬Ë³ÊÖÐÞ¸ÄÁ˼¸¸ö²ÎÊý¡£
alter system set sga_max_size=11g scope=spfile;
alter system  set sga_target=11g scope=spfile ......

ͨ¹ý´´½¨ÐòÁÐÀ´ÊµÏÖ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ