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

OracleÌṩÁË·ÖÇø¼¼Êõ(»ã×ÜÌû)

OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£ 
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯʱֱ½ÓÖ¸¶¨·ÖÇøµÄ·½·¨À´½øÐвéѯ¡£ 
·ÖÇøÌṩÒÔÏÂÓŵ㣺 
ÓÉÓÚ½«Êý¾Ý·ÖÉ¢µ½¸÷¸ö·ÖÇøÖУ¬¼õÉÙÁËÊý¾ÝË𻵵ĿÉÄÜÐÔ£» 
¿ÉÒÔ¶Ôµ¥¶ÀµÄ·ÖÇø½øÐб¸·ÝºÍ»Ö¸´£» 
¿ÉÒÔ½«·ÖÇøÓ³Éäµ½²»Í¬µÄÎïÀí´ÅÅÌÉÏ£¬À´·ÖÉ¢IO£» 
Ìá¸ß¿É¹ÜÀíÐÔ¡¢¿ÉÓÃÐÔºÍÐÔÄÜ¡£ 
OracleÌṩÁËÒÔϼ¸ÖÖ·ÖÇøÀàÐÍ£º 
·¶Î§·ÖÇø£¨range£©£» 
¹þÏ£·ÖÇø£¨hash£©£» 
Áбí·ÖÇø£¨list£©£» 
·¶Î§£­¹þÏ£¸´ºÏ·ÖÇø£¨range-hash£©£» 
·¶Î§£­ÁÐ±í¸´ºÏ·ÖÇø£¨range-list£©¡£ 
OracleµÄÆÕͨ±íûÓа취ͨ¹ýÐÞ¸ÄÊôÐԵķ½Ê½Ö±½Óת»¯Îª·ÖÇø±í£¬±ØÐëͨ¹ýÖؽ¨µÄ·½Ê½½øÐÐת±ä£¬ÏÂÃæ½éÉÜÈýÖÖЧÂʱȽϸߵķ½·¨£¬²¢ËµÃ÷ËüÃǸ÷×ÔµÄÌص㡣 
·½·¨Ò»£ºÀûÓÃÔ­±íÖؽ¨·ÖÇø±í¡£ 
²½Ö裺 
SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, TIME DATE); 
±íÒÑ´´½¨¡£ 
SQL> INSERT INTO T SELECT ROWNUM, CREATED from DBA_OBJECTS; 
ÒÑ´´½¨6264ÐС£ 
SQL> COMMIT; 
Ìá½»Íê³É¡£ 
SQL> CREATE TABLE T_NEW (ID, TIME) PARTITION BY RANGE (TIME) 
  2  (PARTITION P1 VALUES LESS THAN (TO_DATE('2004-7-1', 'YYYY-MM-DD')), 
  3  PARTITION P2 VALUES LESS THAN (TO_DATE('2005-1-1', 'YYYY-MM-DD')), 
  4  PARTITION P3 VALUES LESS THAN (TO_DATE('2005-7-1', 'YYYY-MM-DD')), 
  5  PARTITION P4 VALUES LESS THAN (MAXVALUE)) 
  6  AS SELECT ID, TIME from T; 
±íÒÑ´´½¨¡£ 
SQL> RENAME T TO T_OLD; 
±íÒÑÖØÃüÃû¡£ 
SQL> RENAME T_NEW TO T; 
±íÒÑÖØÃüÃû¡£ 
SQL> SELECT COUNT(*) from T; 
  COUNT(*) 
---------- 
      6264 
SQL> SELECT COUNT(*) from T PARTITION (P1); 
  COUNT(*) 
---------- 
        0 
SQL> S


Ïà¹ØÎĵµ£º

Oracle EBS ÈçºÎÔ½áÖ®Ó¦¸¶(AP)¶ÔÕËÏê½â

Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑ­ÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......

OracleÖеÄnull

²éѯijÁÐֵΪnullµÄ¼Ç¼£º
select *
from    tablename
where col is null;
²éѯijÁÐÖµ²»ÎªnullµÄ¼Ç¼£º
select *
from   tablename
where col is not null;
Õë¶ÔnullµÄ+-*/=!=µÈ²Ù×÷¶¼ÊÇnull£º
null±íʾ²»È·¶¨µÄÖµ£¬Á½¸önull±íʾÁ½¸ö²»È·¶¨µÄÖµ¡¢Î´ÖªµÄÖµ£¬Òò´Ë²»´æÔÚÁ½¸önullµÄÏàµÈ£¬Í ......

ÈçºÎÔÚÁ½Ì¨²»Í¬µÄ»úÆ÷ÉÏ°²×°ÅäÖÃArcSDE £¨oracle£©

ʹÓÃsdeupgradeora9iÓ¦ÓóÌÐòÉý¼¶ºó£¬ÔÙ°´ÕÕÒ»°ãµÄpost·½·¨post,ÔÚÌîдnet service nameʱ£¬Ê¹ÓÃoracle¿Í»§¶ËµÄ net manager ÅäÖÃÒ»¸öÁíһ̨oracleÊý¾Ý¿âµÄservice name;ÆäÓà°´ÕÕ Ò»°ã·½·¨½øÐУ¬PostÍê³Éºó£¬ÐÞ¸Ä$sdehome/dbinit.sde
 set ORACLE_SID = ORCL;Ϊ
set LOCLA=service name;
Æô¶¯·þÎñ¼´¿É¡£ ......

Oracle·ÖÎö±íºÍË÷Òý(analyze)

analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ