oracle¿ª·¢ÖªÊ¶µã
1. ·ÖÇø±í
Oracle
½¨ÒéÈç¹ûµ¥¸ö±í³¬¹ý2G¾Í×îºÃ¶ÔÆä½øÐзÖÇø¡£
¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£»
1)
Range·ÖÇø
¡¡¡¡Range·ÖÇøÄØÊÇÓ¦Ó÷¶Î§±È½Ï¹ãµÄ±í·ÖÇø·½Ê½£¬ËüÊÇÒÔÁеÄÖµµÄ·¶Î§À´×öΪ·ÖÇøµÄ»®·ÖÌõ¼þ£¬½«¼Ç¼´æ·Åµ½ÁÐÖµËù
ÔÚµÄrange·ÖÇøÖУ¬±ÈÈç°´ÕÕʱ¼ä»®·Ö£¬2008Äê1¼¾¶ÈµÄÊý¾Ý·Åµ½a·ÖÇø£¬08Äê2¼¾¶ÈµÄÊý¾Ý·Åµ½b·ÖÇø£¬Òò´ËÔÚ´´½¨µÄʱºòÄØ£¬ÐèÒªÄãÖ¸¶¨»ùÓÚµÄÁУ¬
ÒÔ¼°·ÖÇøµÄ·¶Î§Öµ£¬Èç¹ûijЩ¼Ç¼ÔÝÎÞ·¨Ô¤²â·¶Î§£¬¿ÉÒÔ´´½¨maxvalue·ÖÇø£¬ËùÓв»ÔÚÖ¸¶¨·¶Î§ÄڵļǼ¶¼»á±»´æ´¢µ½maxvalueËùÔÚ·ÖÇøÖУ¬²¢ÇÒ
Ö§³ÖÖ¸¶¨¶àÁÐ×öΪÒÀÀµÁÐ
CREATE TABLE sales
(invoice_no NUMBER,
...
sale_date DATE NOT NULL )
PARTITION BY RANGE (sale_date)
(PARTITION sales1999_q1
VALUES LESS THAN (TO_DATE(‘1999-04-01’,’YYYY-MM-DD’)
TABLESPACE ts_sale1999q1,
...
PARTITION sales1999_q4
VALUES LESS THAN (TO_DATE(‘2000-01-01’,’YYYY-MM-DD’)
TABLESPACE ts_sale1999q4 );
--values less than (maxvalue)
2)
Hash·ÖÇø
¡¡¡¡Í¨³£ÄØ£¬¶ÔÓÚÄÇЩÎÞ·¨ÓÐЧ»®·Ö·¶Î§µÄ±í£¬¿ÉÒÔʹÓÃhash·ÖÇø£¬ÕâÑù¶ÔÓÚÌá¸ßÐÔÄÜ»¹ÊÇ»áÓÐÒ»¶¨µÄ°ïÖú¡£hash
·ÖÇø»á½«±íÖеÄÊý¾Ýƽ¾ù·ÖÅäµ½ÄãÖ¸¶¨µÄ¼¸¸ö·ÖÇøÖУ¬ÁÐËùÔÚ·ÖÇøÊÇÒÀ¾Ý·ÖÇøÁеÄhashÖµ×Ô¶¯·ÖÅ䣬Òò´ËÄã²¢²»ÄÜ¿ØÖÆÒ²²»ÖªµÀÄÄÌõ¼Ç¼»á±»·Åµ½Äĸö·ÖÇø
ÖУ¬hash·ÖÇøÒ²¿ÉÒÔÖ§³Ö¶à¸öÒÀÀµÁС£
create table emp (
empno number(4),
...,
sal number)
partition by hash (empno)
(
PARTITION PART01 TABLESPACE HASH_TS01,
PARTITION PART02 TABLESPACE HASH_TS02,
PARTITION PART03 TABLESPACE HASH_TS03
)
3)
List·ÖÇø
ÄãÄÜ¿ØÖƼǼ´æ´¢ÔÚÄĸö·ÖÇø¡£ËüµÄ·ÖÇøÁÐÖ»ÄÜÓÐÒ»¸ö
£¬Òª´´½¨Ò»¸ödefault·ÖÇø´æ´¢ÄÇЩ²»ÔÚÖ¸¶¨·¶Î§ÄڵļǼ¡£
create table emp (
empno number(4),
...,
location varchar2(30))
partition by list (location)
(partition p1 values ('±±¾©') TABLESPACE PROB_TS01,
partition p2 values ('ÉϺ£','Ìì½ò','ÖØÇì') TABLESPACE PROB_TS02,
partition p3 values ('¹ã¶«
Ïà¹ØÎĵµ£º
ÓÃQt¿ª·¢Oracle³ÌÐòʱ£¬³£»áÓöµ½QOCIÇý¶¯ÎÊÌ⣬Ö÷Òª±íÏÖΪ³ÌÐòÔËÐÐʱ³öÏÖÏÂÃæµÄ´íÎó¡£
QOCI driver not loaded
available drivers: QSQLITE QODBC3 QODBC
Õâ˵Ã÷ûÓа²×°QtÖ§³ÖOracleµÄÇý¶¯¡£
.
ÒªÏë±ÜÃâÕâ¸öÎÊÌ⣬µÚÒ»ÖÖ·½·¨ÊÇʹÓÃЧÂʵÍϲ¢ÇÒ·ÑʵÄODBC£»µÚ¶þÖÖ·½·¨¾ÍÊÇ°²×°QOCIÇý¶¯¿©~
.
Ҫ˵һϵÄÊÇ£ºQOCIÔÚqt ......
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......
OracleÓ¦ÓÃÌåϵ½á¹¹
°üº¬ÈçÏÂÖ÷Ì⣺
¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
¡£¶à²ãÌåϵ½á¹¹¸ÅÊö
¡£OracleÍøÂç·þÎñ¸ÅÊö
1¡£¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹¼ò½é
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿âÓ¦ÓóÌÐòÓëÊý¾Ý¿â±»·ÖΪÁ½²¿·Ö£ºÇ°¶Ë(front-end)»ò³ÆΪ¿Í»§¶Ë(client)£¬ºǫ́(back-end)»ò³ÆΪ·þÎñ¶Ë---Õâ¾ÍÊÇ¿Í»§¶Ë/·þÎñÆ÷Ìåϵ½á¹¹Ãû×ÖµÄÓÉÀ´¡£ ......
OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
ÔÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......