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

oracleÊý¾Ý²Ö¿âÖÐÈýÖÖÓÅ»¯


¶ÔÓÚÎÒÃÇÕâ¸öÏîÄ¿À´Ëµ£¬Êý¾Ý¿âµÄ´æÈ¡µÄÐÔÄܾö¶¨ÁËÊý¾ÝÌṩµÄÐÔÄÜ¡£ÓÅ»¯µÄ´óÖµÄÔ­ÀíÖ»ÓÐÁ½¸ö£ºÒ»ÊÇÊý¾Ý·Ö¿é´æ·Å£¬±ãÓÚÊý¾ÝµÄת´¢ºÍ¹ÜÀí£»¶þÊÇÖм䴦Àí£¬Ìá¸ßÊý¾ÝÌṩµÄËÙ¶È¡£
»ùÓÚÉÏÃæÁ½¸ö¸ù±¾µÄÔ­Àí£¬½èÖúÓÚÊý¾Ý²Ö¿âµÄ¸ÅÄÁоÙÊý¾Ý¿âµÄÓÅ»¯·½Ê½£º
1£® ·ÖÇø
ÔÚÊý¾Ý²Ö¿âÖУ¬ÊÂʵ±í£¬Ë÷Òý±í£¬Î¬¶È±í·Ö´¦ÓÚÈý¸ö²»Í¬µÄ±í¿Õ¼äµ±ÖУ¨ÔÚ²¿ÊðµÄʱºò£¬×îºÃÊDz¿Êðµ½²»Í¬µÄ´ÅÅÌÉÏ£©¡£ÕâÑù×Ó×öµÄÔ­Òò¾ÍÊDZãÓÚ²¢·¢²Ù×÷£¬ÆäʵÊý¾Ý²Ö¿âºÍÆÕͨµÄÊý¾Ý¿âÖ®¼äûÓÐÑϸñµÄ½çÏÞ£¬Ö÷Òª»¹ÊDz¿ÊðÉÏ£¬µ±È»oracle±¾Éí»áΪÊý¾Ý²Ö¿âÖеēÊÂʵ±í”Éú³É“֪ʶ¿â”µÈ²Ù×÷£¬±£Ö¤¸ü¿ìµÄÊý¾ÝÌṩЧÂÊ£¬Æäʵ¿ÉÒÔ½èÖúÓÚjobºÍÍⲿ³ÌÐòÀ´µ÷¶È´æ´¢¹ý³ÌʵÏÖ¡£»ùÓÚÕâ¸ö˼·£¬±¾ÏîÄ¿Êý¾Ý¿âÖеÄË÷Òý½«ºÍÊÂʵ±í·Ö¿ªÎ¬»¤£¬µ±È»Õâ³Æ²»ÉÏ·ÖÇø£¨£©¡£ÕæÕýµÄ·ÖÇøÊÇÖ¸ÏÂÃæµÄÄÚÈÝ¡£
·ÖÇø¾ÍÊÇpartition/subpartition£¬¶ÔÓÚÊÂʵ±í±¾ÉíÀ´Ëµ£¬ÒÔÔÂΪµ¥Î»×÷partition¹ÒÔØµ½²»Í¬±í¿Õ¼äÉÏ¡£¾ßÌåµÄʾÀýÈçÏ£º
create table T_LOGNODE_RECORD
(
……
  CALLIN_HH      NUMBER(2) not null,
  CALLIN_DD      NUMBER(2) not null,
  CALLIN_MONTH  NUMBER(2) not null,
  CALLIN_YEAR    NUMBER(4) not null,
  MONTH_MOD     NUMBER(1) not null
)
PARTITION BY LIST (MONTH_MOD) 
(
PARTITION P0 VALUES (0) TABLESPACE TS0, 
PARTITION P1 VALUES (1)  TABLESPACE TS1, 
PARTITION P2 VALUES (DEFAULT) TABLESPACE TS2
);
ÉÏÊöµÄ´úÂëÖÐÒÔMONTH_MOD×Ö¶Î×÷Ϊ·ÖÇø±ê×¼£¬½«T_LOGNODE_RECORD·Öµ½Èý¸ö²»Í¬µÄ±í¿Õ¼ä£¨TS0£¬TS1£¬TS2£©ÖУ¬ÕâÀïÓÐÒ»¸ö¼¼ÇÉ£¬MONTH_MOD = Ô·Ýmod3,ÕâÑù×Ó¿ÉÒÔ²»ÐèÒªÈ˹¤µÄά»¤ÄĸöÔ·ÖÈëÄĸö·ÖÇø¡£µ±È»¼òµ¥µÄÒÔÔÂ×÷Ϊ·ÖÇøÖ®ºó£¬¶ÔÓÚÎÒÃǵ±Ç°µÄÊý¾Ý¿âÀ´Ëµ»¹ÊÇÔ¶Ô¶²»¹»µÄ£¬ÒòΪ¼´Ê¹ÊÇÒ»¸öÔµÄÊý¾ÝÒÀÈ»ÊǺܾ޴óµÄ£¬ÄÇôÐèÒªÎÒÃÇ×öSUBPARTITION£¬×ö·¨µÄʾÀýΪ£º
create table T_LOGNODE_RECORD
(
……
  CALLIN_DD   NUMBER(2) not null,
  MONTH_MOD NUMBER(1) not null
)
PARTITION BY RANGE(MONTH_MOD)
SUBPARTITION BY LIST(CALLIN_DD)
SUBPARTITION TEMPLATE
(
SUBPARTITION SUBP1 values (1),
SUBPARTITION SUBP2 values (2),
SUBPA


Ïà¹ØÎĵµ£º

ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû

ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû
¼ÙÈçÒª°ÑÖ÷»úÃû¸ÄΪoratest¡£
$±íʾoracleÓû§²Ù×÷£»
#±íʾrootÓû§²Ù×÷¡£
DB£ºoracle10.2
OS£ºRHEL4.5
µÚÒ»²½£¬¹Ø±ÕÊý¾Ý¿âºÍ¼àÌý£¬dbconsole£º
$ dbshut
$ lsnrctl stop
µÚ¶þ²¿£º
# hostname oratest
µÚÈý²½£º
# vi /etc/sysconfig/network
¸ü¸Ähostname²ÎÊý¡£
µÚËIJ½ ......

OracleÊý¾Ý¿â±í¿Õ¼ä²Ù×÷

// ½¨Á¢±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
create TABLESPACE EAS_D_sptcc0_STANDARD DATAFILE 'F:\oracledb\EAS_D_sptcc0_STANDARD.dbf' size 10000M EXTENT MANAGEMENT local;
// ɾ³ý±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
DROP TABLESPACE temp_data INCLUDING CONTENTS AND DATAFILES;
// ½¨Á¢ÁÙʱ±í¿Õ¼ä¡£
CREATE TEMPORARY TABLESPA ......

linux oracle °²×°

linuxÏÂoracle°²×°£º
Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶     
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£     
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9 ......

Oracle µÄÊý¾Ýµ¼Èëµ¼³ö¼° Sql Loader (sqlldr) µÄÓ÷¨

Ô­ÎÄ:http://www.blogjava.net/Unmi/archive/2009/01/05/249956.html
ÔÚ Oracle Êý¾Ý¿âÖУ¬ÎÒÃÇͨ³£ÔÚ²»Í¬Êý¾Ý¿âµÄ±í¼ä¼Ç¼½øÐи´ÖÆ»òÇ¨ÒÆÊ±»áÓÃÒÔϼ¸ÖÖ·½·¨£º
1. A ±íµÄ¼Ç¼µ¼³öΪһÌõÌõ·ÖºÅ¸ô¿ªµÄ insert Óï¾ä£¬È»ºóÖ´ÐвåÈëµ½ B ±íÖÐ
2. ½¨Á¢Êý¾Ý¿â¼äµÄ dblink£¬È»ºóÓà create table B as select * from A ......

ORACLEÆô¶¯Ô­Àí

Checkpoint
        ºÜ¶àÈ˶¼°ÑcheckpointµÄ¸ÅÄî¸ø¸´ÔÓ»¯ÁË£¬ÆäʵcheckpointÕâ¸öÊý¾Ý¿â¸ÅÄîÒýÈëµÄÕæÕýÒâÒå¾ÍÊÇÓÃÀ´¼õÉÙÔÚÊý¾Ý¿â
»Ö¸´¹ý³ÌÖÐËù»¨µÄʱ¼ä(instance recovery),ÄÇôcheckpointÊÇÓÉË­À´×öµÄÄØ?ÎÒÃǶ¼ÖªµÀÊý¾Ý¿âÖÐÓиöCKPT½ø³Ì£¬ÕâÊǸö
¿ÉÑ¡½ø³Ì£¬µ«ÊÇÕæÕýÖ´Ðмì²éµãµÄÈÎÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ