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

±±´óÇàÄñoracleѧϰ±Ê¼Ç7

oracle±í·ÖÇø
oracleÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼­²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
Partition ·ÖÇøÃû values less than (85), --75¡«85
Partition ·ÖÇøÃû values less than (maxvalue) --85¡«max
);
É¢ÁзÖÇø£º
ͨ¹ýÖƶ¨·ÖÇø±àºÅÀ´¾ùÔȵķֲ¼Êý¾ÝµÄ·½·¨
ͨ¹ýHashº¯Êý(oracleϵͳÌṩ)½«Êý¾ÝÓ³Éäµ½ÏàÓ¦µÄ·ÖÇøÉÏ¡£
Óï·¨£ºPartition by hash(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû,
Partition ·ÖÇøÃû
);
¸´ºÏ·ÖÇø£º
ÏȶÔÊý¾Ý½øÐз¶Î§·ÖÇø£¬È»ºóÔÙÿ¸ö×Ó·ÖÇøÄÚ½øÐÐÉ¢ÁзÖÇø¡£
Óï·¨£ºPartition by range(×Ö¶ÎÃû)
Subpartition by hash(×Ö¶ÎÃû)(
Partition p1 values less than(10),
(subpartition sp1,subpartition sp2),
Partition p2 values less than(20),
(subpartition sp3,subpartition sp4)
);
ÕâÑù×ӾͷֳÉÁË4¸ö·ÖÇø
Áбí·ÖÇø£º
ÔÊÐíÓû§Ã÷È·µÄ¿ØÖÆÐе½·ÖÇøµÄÓ³Éä
ÔÊÐí°´×ÔÈ»·½Ê½¶ÔÎÞÐò»ò²»Ïà¹ØµÄÊý¾Ý½øÐзÖ×éºÍ×éÖ¯
Óï·¨£º
Partition by list(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values('Öµ','Öµ','Öµ')),
Partition ·ÖÇøÃû values('Öµ')),
Partition ·ÖÇøÃû values('Öµ','Öµ'))
);
¶Ô·ÖÇøÖÐÊý¾Ý½øÐвéѯʱ£¬¿ÉÒÔÖ¸¶¨²éѯµÄ·ÖÇø£¬È磺select * from student partition(p1);


Ïà¹ØÎĵµ£º

Oracle ×Ö·û¼¯µÄ²é¿´ºÍÐÞ¸Ä




< type="text/javascript">
< type="text/javascript">
http://blog.csdn.net/tianlesoftware/archive/2009/12/01/4915223.aspx
 
Ò»¡¢Ê²Ã´ÊÇ
Oracle
×Ö·û¼¯

      
Oracle
×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ
,
ÓдóÐ¡Ö ......

ORACLE¼òÒ׿ͻ§¶Ë°²×°ÓëʹÓ÷½·¨

£¨1£©¶Ôwindows»úÆ÷£º
      #½«Oracle installclientѹËõ°ü¿½±´µ½D:\oracle£¬²¢Ñ¡Ôñ½âѹÖÁµ±Ç°Ä¿Â¼£¨»òÆäËûĿ¼£¬¼ÇµÃ¸ü¸ÄÏàÓ¦µÄ»·¾³±äÁ¿¼´¿É£©
      #ÉèÖû·¾³±äÁ¿£º
      Path£¨ÔÚ±äÁ¿ÖмÓÈ룩    ......

ÔÚIBM AIXÉÏ°²×°Oracle RAC (RS/6000)

±¾Îijö×Ô “inthirties£¨ÄÐÈËÈýÊ®£©”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦£¬Î´¾­×÷ÕßÐí¿ÉתÔØ£¬±Ø×·¾¿·¨ÂÉÔðÈΡ£
ÔÚIBM AIXÉÏ°²×°Oracle RAC (RS/6000)
Ä¿µÄ
´ËÎĵµÏò¶ÁÕßÌṩÈçºÎ°²×°Ò»¸öȺ¼¯£¬°²×°RAC£¬²¢ÔÚIBM AIX HACMP/ES (CRM) 4.4.xÉÏÆô¶¯Ò»¸öȺ¼¯Êý¾Ý¿âµÄÊÖ°ÑÊÖÖ¸µ¼Êֲᣬ¶ÔÓÚ¹ØÓÚÈκÎÕâЩ²½ÖèµÄÆäËü½ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç4 5

sql plus ±£´æsqlÓï¾ä
save 'd:\sql.txt';½«oracle»º´æÇøÖеÄsqlÓï¾ä´æÈëÎļþ¡£
get 'd:\sql.txt';´ËʱsqlÓï¾ä±»¼ÓÔص½oracle»º´æÇø£¬Ê¹ÓÃrun;ÃüÁîÖ´ÐÐsqlÓï¾ä¡£
@'d:\sql.txt';¼ÓÔØsqlÓï¾ä²¢Ö±½ÓÖ´ÐС£
oracleÖеĺ¯Êý
 
1. ת»»º¯Êý
TO_CHAR(number[,format])
½«Ò»¸öÊýֵת»»³ÉÓëÖ®µÈ¼ÛµÄ×Ö·û´®.Èç¹û²»Ö¸ ......

oracleÖ´Ðмƻ®

±¾ÎĽéÉÜÁËORACLEÖ´Ðмƻ®µÄһЩ»ù±¾¸ÅÄ¹©Ñ§Ï°Ó¦Óá£
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ