±±´óÇàÄñ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 10.2.0.4 patchµÄÏÂÔصØÖ·Áбí
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://d ......
OracleÌåϵ½á¹¹Öеĸ÷ÖÖÃû³Æ
¹Ø¼ü×Ö: oracle, Êý¾Ý¿âÃû, ʵÀýÃû, ÓòÃû, È«¾ÖÊý¾Ý¿âÃû, ·þÎñÃû, ÍøÂç·þÎñÃû
Ò»¡¢Êý¾Ý¿âÃû
¡¡¡¡Êý¾Ý¿âÃûÊÇÊý¾Ý¿âµÄ“Éí·ÝÖ¤ºÅÂ딣¬ÓÃÓÚ±êʾһ¸öÊý¾Ý¿â¡£ÔÚ²ÎÊýÎļþÖÐÓÃDB_NAME±íʾ¡£
¡¡¡¡Êý¾Ý¿âÃûÊÇÔÚ°²×°Êý¾Ý¿â¡¢´´½¨ÐµÄÊý¾Ý¿â¡¢´´½¨Êý¾Ý¿â¿ ......
oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü
°ÑÏÂÃæµÄµØÖ·¸´ÖƵ½Ñ¶À×Àï¾Í¿ÉÒÔÏÂÔØ.
---------------------------------------------------------------------------------------------------
ORACLE 9i
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle ......
±¾ÎÄÊÇOracle¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ£¬´ð°¸½ö¹©²Î¿¼……
¡¡¡¡1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
¡¡¡¡½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ ......