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

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄãÔÙÖØÐ°²×°ÊÔÊÔ ±¨µÄÊÇʲô´íÎó£¿ ÊDz»ÊÇ֮ǰװ¹ý£¿

http://topic.csdn.net/u/20090626/11/ece71a6b-fae4-4860-8e6d-4345ae9aac83.html

ÔÚ°²×°¿ªÊ¼Ê±£¬OracleÒª¶Ôϵͳ½øÐмì²âÓÐÍø¿¨µÄÑ¡Ïîûͨ¹ý¼ìÑ飬ÓÚÊÇÎÒÊÖ¹¤¶Ô¸ÃÏî´òÁË¡Ì £¬ÏÔʾÒÑÅäÖã¬ÕâÑù±ã¿ªÊ¼ÁËËùνµÄÕý³£°²×°¡£ 

»òÕß
ÉèÖá°Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷¡±£¬ÓÚÊÇÎÒ¾ÍÊÖ¹¤¼ÓÁËÒ»¸ö£¬¾ßÌå·½·¨Ï£º 
   
  ´ò¿ª¡°¿ØÖÆÃæ°å¡±£¬Ë«»÷¡°Ìí¼ÓÓ²¼þ¡±Í¼±ê£¬ÔÚ¡°Ìí¼ÓÓ²¼þÏòµ¼¡±Öе¥»÷¡°ÏÂÒ»²½¡±°´Å¥£¬¸ÃÏòµ¼»áËÑË÷×î½üÁ¬½Óµ½¼ÆËã»úµ«ÉÐδ°²×°µÄÐÂÓ²¼þ¡£ÓÉÓÚÎÒÃDz¢Ã»ÓÐÕæÕýΪ¼ÆËã»úÁ¬½ÓеÄÓ²¼þ£¬ËùÒÔϵͳµ±È»ÎÞ·¨ÕÒµ½ÐÂÓ²¼þ£¬Òò´Ë»áµ¯³öÒ»¸öѯÎÊÓ²¼þÊÇ·ñÒѰ²×°µÄ¶Ô»°¿ò£¬ÔڸöԻ°¿òÖÐÑ¡Ôñ¡°ÊÇ£¬ÎÒÒѾ­Á¬½ÓÁË´ËÓ²¼þ¡±£¬µ¥»÷ ¡°ÏÂÒ»²½¡±°´Å¥¡£ 

1¡¢ÔÚ³öÏֵġ°ÒѰ²×°µÄÓ²¼þ¡±ÁбíÖУ¬Ñ¡Ôñ×îºóÒ»Ïî¡°Ìí¼ÓеÄÓ²¼þÉ豸¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼ÌÐø¡£ 

2¡¢ÔÚ½ÓÏÂÀ´µ¯³öµÄ¶Ô»°¿òÖУ¬Ñ¡Ôñ¡°°²×°ÎÒÊÖ¶¯´ÓÁбíÖÐÑ¡ÔñµÄÓ²¼þ¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥£¬ÔÚ³öÏÖµÄÓ²¼þÁбíÖÐÑ¡Ôñ¡°ÍøÂçÊÊÅäÆ÷¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¡£ 

3¡¢ÔÚÑ¡ÔñÍø¿¨¶Ô»°¿òÖУ¬¡°³§ÉÌ¡±Ñ¡Ôñ¡°Microsoft¡±£¬¡°Íø¿¨¡±Ñ¡Ôñ¡°Microsoft Loopback Adapter¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼´¿É¿ªÊ¼°²×°£¬×îºóµ¥»÷¡°Íê³É¡±°´Å¥¡£ 


Ïà¹ØÎÊ´ð£º

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ